<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1998849042;
mso-list-type:hybrid;
mso-list-template-ids:1126753664 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>We are working with the pgsql RA and pacemaker 1.1.9. We are having trouble understanding why our slave resource doesn’t come out of DISCONNECT after we online the node. We did the following:<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Put node running the Master (usrv-tsegp8) in Standby. The old slave became the master and the Ip resources moved over.<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Took node (usrv-tsegp8) out of standby. Postgres started and went into the HS:alone state but data status stayed disconnect.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>How do we get back to the sync state? <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>usrv-tsegp9:~ # crm_mon -Afo1<o:p></o:p></p><p class=MsoNormal>Last updated: Fri Nov 15 07:43:59 2013<o:p></o:p></p><p class=MsoNormal>Last change: Fri Nov 15 07:43:46 2013 by root via crm_attribute on usrv-tsegp9<o:p></o:p></p><p class=MsoNormal>Stack: classic openais (with plugin)<o:p></o:p></p><p class=MsoNormal>Current DC: usrv-tsegp8 - partition with quorum<o:p></o:p></p><p class=MsoNormal>Version: 1.1.9-2db99f1<o:p></o:p></p><p class=MsoNormal>2 Nodes configured, 2 expected votes<o:p></o:p></p><p class=MsoNormal>5 Resources configured.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Online: [ usrv-tsegp8 usrv-tsegp9 ]<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> stonith-sbd (stonith:external/sbd): Started usrv-tsegp9<o:p></o:p></p><p class=MsoNormal> Master/Slave Set: msPostgresql [FM_pgsql]<o:p></o:p></p><p class=MsoNormal> Masters: [ usrv-tsegp9 ]<o:p></o:p></p><p class=MsoNormal> Slaves: [ usrv-tsegp8 ]<o:p></o:p></p><p class=MsoNormal> Resource Group: master-group<o:p></o:p></p><p class=MsoNormal> FM_access_ip (ocf::unisys:IPaddr4): Started usrv-tsegp9<o:p></o:p></p><p class=MsoNormal> FM_pgsqlrep_ip (ocf::unisys:IPaddr4): Started usrv-tsegp9<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Attributes:<o:p></o:p></p><p class=MsoNormal>* Node usrv-tsegp8:<o:p></o:p></p><p class=MsoNormal> + FM_pgsql-data-status : DISCONNECT<o:p></o:p></p><p class=MsoNormal> + FM_pgsql-status : HS:alone<o:p></o:p></p><p class=MsoNormal> + master-FM_pgsql : -INFINITY<o:p></o:p></p><p class=MsoNormal>* Node usrv-tsegp9:<o:p></o:p></p><p class=MsoNormal> + FM_pgsql-data-status : LATEST<o:p></o:p></p><p class=MsoNormal> + FM_pgsql-master-baseline : 0000000004000000<o:p></o:p></p><p class=MsoNormal> + FM_pgsql-status : PRI<o:p></o:p></p><p class=MsoNormal> + master-FM_pgsql : 1000<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Operations:<o:p></o:p></p><p class=MsoNormal>* Node usrv-tsegp8:<o:p></o:p></p><p class=MsoNormal> stonith-sbd: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2825) stop: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_access_ip: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2936) monitor: interval=10000ms rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2984) stop: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_pgsqlrep_ip: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2942) monitor: interval=10000ms rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2978) stop: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_pgsql:0: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2951) probe: rc=8 (master)<o:p></o:p></p><p class=MsoNormal> + (2954) monitor: interval=3000ms rc=8 (master)<o:p></o:p></p><p class=MsoNormal> + (2993) start: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2999) monitor: interval=4000ms rc=0 (ok)<o:p></o:p></p><p class=MsoNormal>* Node usrv-tsegp9:<o:p></o:p></p><p class=MsoNormal> stonith-sbd: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2075) start: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_access_ip: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2226) start: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2230) monitor: interval=10000ms rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_pgsqlrep_ip: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2232) start: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2236) monitor: interval=10000ms rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> FM_pgsql:0: migration-threshold=1<o:p></o:p></p><p class=MsoNormal> + (2218) promote: rc=0 (ok)<o:p></o:p></p><p class=MsoNormal> + (2224) monitor: interval=3000ms rc=8 (master)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>usrv-tsegp9:~ # crm configure show<o:p></o:p></p><p class=MsoNormal>node usrv-tsegp8 \<o:p></o:p></p><p class=MsoNormal> attributes standby="off" FM_pgsql-data-status="LATEST"<o:p></o:p></p><p class=MsoNormal>node usrv-tsegp9 \<o:p></o:p></p><p class=MsoNormal> attributes standby="off" FM_pgsql-data-status="STREAMING|SYNC"<o:p></o:p></p><p class=MsoNormal>primitive FM_access_ip ocf:unisys:IPaddr4 \<o:p></o:p></p><p class=MsoNormal> params ip="172.32.229.101" dotted_netmask="255.255.0.0" nic="eth1" \<o:p></o:p></p><p class=MsoNormal> op start interval="0s" timeout="60s" on-fail="restart" \<o:p></o:p></p><p class=MsoNormal> op monitor interval="10s" timeout="60s" on-fail="restart" \<o:p></o:p></p><p class=MsoNormal> op stop interval="0s" timeout="60s" on-fail="block"<o:p></o:p></p><p class=MsoNormal>primitive FM_pgsql ocf:unisys:pgsql \<o:p></o:p></p><p class=MsoNormal> params rep_mode="sync" start_opt="-p 5432" node_list="usrv-tsegp8 usrv-tsegp9" primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5 keepalives_count=5" master_ip="172.32.229.102" logfile="/var/tmp/pslog" restart_on_promote="true" \<o:p></o:p></p><p class=MsoNormal> op start interval="0s" timeout="60s" \<o:p></o:p></p><p class=MsoNormal> op monitor interval="4s" timeout="60s" \<o:p></o:p></p><p class=MsoNormal> op monitor interval="3s" role="Master" timeout="60s" \<o:p></o:p></p><p class=MsoNormal> op demote interval="0s" timeout="60s" on-fail="stop" \<o:p></o:p></p><p class=MsoNormal> op stop interval="0s" timeout="60s" on-fail="block"<o:p></o:p></p><p class=MsoNormal>primitive FM_pgsqlrep_ip ocf:unisys:IPaddr4 \<o:p></o:p></p><p class=MsoNormal> params ip="172.32.229.102" dotted_netmask="255.255.0.0" nic="eth1" \<o:p></o:p></p><p class=MsoNormal> op start interval="0s" timeout="60s" on-fail="stop" \<o:p></o:p></p><p class=MsoNormal> op monitor interval="10s" timeout="60s" on-fail="restart" \<o:p></o:p></p><p class=MsoNormal> op stop interval="0s" timeout="60s" on-fail="ignore"<o:p></o:p></p><p class=MsoNormal>primitive stonith-sbd stonith:external/sbd<o:p></o:p></p><p class=MsoNormal>group master-group FM_access_ip FM_pgsqlrep_ip<o:p></o:p></p><p class=MsoNormal>ms msPostgresql FM_pgsql \<o:p></o:p></p><p class=MsoNormal> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"<o:p></o:p></p><p class=MsoNormal>colocation pgsql_colocation inf: master-group msPostgresql:Master<o:p></o:p></p><p class=MsoNormal>order pgsql_order-1 0: msPostgresql:promote master-group:start symmetrical=false<o:p></o:p></p><p class=MsoNormal>order pgsql_order-2 0: msPostgresql:demote master-group:stop symmetrical=false<o:p></o:p></p><p class=MsoNormal>property $id="cib-bootstrap-options" \<o:p></o:p></p><p class=MsoNormal> stonith-enabled="true" \<o:p></o:p></p><p class=MsoNormal> no-quorum-policy="ignore" \<o:p></o:p></p><p class=MsoNormal> placement-strategy="balanced" \<o:p></o:p></p><p class=MsoNormal> dc-version="1.1.9-2db99f1" \<o:p></o:p></p><p class=MsoNormal> cluster-infrastructure="classic openais (with plugin)" \<o:p></o:p></p><p class=MsoNormal> expected-quorum-votes="2" \<o:p></o:p></p><p class=MsoNormal> crmd-transition-delay="0s" \<o:p></o:p></p><p class=MsoNormal> last-lrm-refresh="1384519310"<o:p></o:p></p><p class=MsoNormal>rsc_defaults $id="rsc-options" \<o:p></o:p></p><p class=MsoNormal> resource-stickiness="INFINITY" \<o:p></o:p></p><p class=MsoNormal> migration-threshold="1" \<o:p></o:p></p><p class=MsoNormal> failure-timeout="60s"<o:p></o:p></p><p class=MsoNormal>op_defaults $id="op-options" \<o:p></o:p></p><p class=MsoNormal> timeout="600" \<o:p></o:p></p><p class=MsoNormal> record-pending="false"<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for any help<o:p></o:p></p><p class=MsoNormal>Diane Schaefer<o:p></o:p></p></div></body></html>