<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 18px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
I made two more tweaks on lines 240 and 255 changing is_ocf_ture to ocf_is_ture.</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 18px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 18px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
Then I exported the paris and values using this as a guide <a href="http://www.clusterlabs.org/wiki/Debugging_Resource_Failures">
http://www.clusterlabs.org/wiki/Debugging_Resource_Failures</a></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 18px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
<span style="font: 12.0px Courier; color: #000000; background-color: #f9f9f9">export OCF_RESKEY_</span>pcp_admin_username="root"</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_admin_password</span><span style="color: #93a1a1"><b>=</b>0rionChive</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_admin_port</span><span style="color: #93a1a1"><b>=</b>9898</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_admin_host</span><span style="color: #93a1a1"><b>=</b>localhost</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pgpool_bin</span><span style="color: #93a1a1"><b>=</b>/usr/bin/pgpool</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
<span style="font: 12.0px Courier; color: #000000; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_attach_node_bin</span><b>=</b>/usr/bin/pcp_attach_node</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
<span style="font: 12.0px Courier; color: #000000; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_detach_node_bin</span><b>=</b>/usr/bin/pcp_detach_node</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
<span style="font: 12.0px Courier; color: #000000; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_node_count_bin</span><b>=</b>/usr/bin/pcp_node_count</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; color: rgb(147, 161, 161); ">
<span style="font: 12.0px Courier; color: #000000; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">pcp_node_info_bin</span><b>=</b>/usr/bin/pcp_node_info</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Courier; background-color: rgb(249, 249, 249); ">
export OCF_RESKEY_<span style="font: 12.0px Menlo; color: #268bd2; background-color: transparent">stop_mode</span><span style="font: 12.0px Menlo; color: #93a1a1; background-color: transparent"><b>=</b>f</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">auto_reconnect</span><span style="color: #93a1a1"><b>=</b>true</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Menlo; ">
<span style="font: 12.0px Courier; background-color: #f9f9f9">export OCF_RESKEY_</span><span style="color: #268bd2">fail_on_detached</span><span style="color: #93a1a1"><b>=</b>true</span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
Then I manually ran the RA script with all of its options and verified the error code reported was correct. I don't see any issues with the resource agent script…but I still see the errors in crm_mon and in the logs (<span class="Apple-style-span" style="font-family: 'Times New Roman', serif; font-size: 16px; "><b>Apr
24 08:23:48 <a href="http://pg1.stage.net/" style="color: blue; text-decoration: underline; ">pg1.stage.net</a> lrmd: [28471]: WARN: Managed pgPool:monitor process 28484 exited with return code 2)</b></span></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
Results of RA script …...</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Start PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 start ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[29968]: INFO: default Successfully started pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[29968]: DEBUG: default start returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Status of running PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 status ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30036]: DEBUG: default status returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Stop PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 stop ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30065]: INFO: Using /usr/bin/pgpool -m f stop to stop pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
stop request sent to pgpool. waiting for termination....done.</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30065]: INFO: default Successfully stopped pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30065]: DEBUG: default stop returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Status of stopped PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 status ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30076]: DEBUG: default status returned 7</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
7</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b><br>
</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Monitor of stopped PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 monitor ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30116]: DEBUG: default monitor returned 7</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
7</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Start PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 start ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30123]: INFO: default Successfully started pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30123]: DEBUG: default start returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Monitor of running PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 monitor ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30190]: DEBUG: default monitor returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Validation of running PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 validate-all ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30220]: DEBUG: default validate-all returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Stop PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 stop ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30228]: INFO: Using /usr/bin/pgpool -m f stop to stop pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
stop request sent to pgpool. waiting for termination....done.</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30228]: INFO: default Successfully stopped pgpool-II</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30228]: DEBUG: default stop returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<br>
</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; ">
<b>Validation of stopped PGPool-II</b></div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
[root@pg1 heartbeat]# /usr/lib/ocf/resource.d/heartbeat/pgpool2 validate-all ; echo $?</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
pgpool2[30238]: DEBUG: default validate-all returned 0</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 13px; font: normal normal normal 12px/normal Helvetica; ">
0</div>
<div><br>
</div>
<div>
<div>On Apr 24, 2012, at 10:59 AM, Steven Bambling wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
After doing some searching on setting up "PGPool-HA" to limit pgpool being a single point of failure it looks like development on the heartbeat project has reduced greatly and development has shifted to corosync (backed by RedHat and Suse) that is recommend
by pacemaker. <o:p></o:p></div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
I've found an article here <a href="http://masteinhauser.github.com/blog/2011/09/24/pacemaker-pgpool2/" style="color: blue; text-decoration: underline; ">http://masteinhauser.github.com/blog/2011/09/24/pacemaker-pgpool2/</a> that explains using pacemaker with
pgpool-II. In the post a resource agent is provided. There was a quick tweak I had to make with the PGPool-II path created by the installed RPMs obtained from <a href="http://yum.postgresql.org/9.1/redhat/rhel-$releasever-$basearch" style="color: blue; text-decoration: underline; ">http://yum.postgresql.org/9.1/redhat/rhel-$releasever-$basearch</a>.
I modified the below marked in bold from <b>/var/run/pgpool/</b> to<b>/var/run/pgpool-II-91</b><o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
pgpool2_status() {<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
if [ ! -r "/<b>var/run/pgpool-II-91/pgpool.pid</b>" ]; then<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
return $OCF_NOT_RUNNING<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
fi<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
ps_info=$(ps ax | grep "pgpool" | grep $(cat <b>/var/run/pgpool-II-91/pgpool.pid</b>))<o:p></o:p></div>
</div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
I used the following parameters to created the resource<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">crm configure primitive pgPool ocf:heartbeat:pgpool2 </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_admin_username</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">postgres </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_admin_password</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">password </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_admin_port</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">9898 </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_admin_host</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">localhost </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pgpool_bin</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">/usr/bin/pgpool </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_attach_node_bin</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">/usr/bin/pcp_attach_node </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_detach_node_bin</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">/usr/bin/pcp_detach_node </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_node_count_bin</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">/usr/bin/pcp_node_count </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">pcp_node_info_bin</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">/usr/bin/pcp_node_info </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">stop_mode</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">f </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); "><o:p></o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">auto_reconnect</span><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">t </span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); "><o:p></o:p></span></div>
</div>
<div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(147, 161, 161); ">params </span><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(38, 139, 210); ">fail_on_detached</span><b><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(147, 161, 161); ">=</span></b><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(147, 161, 161); ">true </span><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(220, 50, 47); ">\</span><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(38, 139, 210); "><o:p></o:p></span></div>
</div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span class="apple-style-span"><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">op monitor </span></span><span class="apple-style-span"><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); ">interval</span></span><span class="apple-style-span"><b><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">=</span></b></span><span class="apple-style-span"><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(147, 161, 161); ">1min</span></span><span style="font-size: 9pt; font-family: Menlo, serif; color: rgb(38, 139, 210); "><o:p></o:p></span></div>
</div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<span style="font-size: 9pt; font-family: Menlo, serif; "><o:p> </o:p></span></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
The resource is looks to be created correctly but when I (re)start the corosync service and look at crm_mon I see some failed actions<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
============<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Last updated: Tue Apr 24 08:31:08 2012<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Last change: Tue Apr 24 08:02:31 2012 via cibadmin on <a href="http://pg1.stage.arin.net/" style="color: blue; text-decoration: underline; ">pg1.stage.arin.net</a><o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Stack: openais<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Current DC: <a href="http://pg2.stage.arin.net/" style="color: blue; text-decoration: underline; ">pg2.stage.arin.net</a> - partition with quorum<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Version: 1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
2 Nodes configured, 2 expected votes<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
2 Resources configured.<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
============<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Online: [ <a href="http://pg1.stage.net/" style="color: blue; text-decoration: underline; ">pg1.stage.net</a> <a href="http://pg2.stage.net/" style="color: blue; text-decoration: underline; ">pg2.stage.net</a> ]<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
ClusterIP<span class="apple-tab-span"> </span>(ocf::heartbeat:IPaddr2):<span class="apple-tab-span"><o:p></o:p></span></div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Started <a href="http://pg2.stage.net/" style="color: blue; text-decoration: underline; ">pg2.stage.net</a><o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Failed actions:<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
pgPool_monitor_0 (node=pg1.stage.net, call=3, rc=2, status=complete): invalid parameter<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
pgPool_monitor_0 (node=pg2.stage.net, call=3, rc=2, status=complete): invalid parameter<o:p></o:p></div>
</div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
When I look in the /var/log/cluster/corosync.log I see this error <b>Apr 24 08:23:48 <a href="http://pg1.stage.net/" style="color: blue; text-decoration: underline; ">pg1.stage.net</a> lrmd: [28471]: WARN: Managed pgPool:monitor process 28484 exited with return
code 2</b><o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
Has anyone ran into a similar experience or have suggestions for a cluster solution with pgpool-II.<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p> </div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
v/r<o:p></o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
<o:p> </o:p></div>
</div>
<div>
<div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; ">
STEVE</div>
</div>
</div>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: http://www.clusterlabs.org<br>
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf<br>
Bugs: http://bugs.clusterlabs.org<br>
</blockquote>
</div>
<br>
</body>
</html>