<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><br>Hi list, <br>i have manage to get rid of the errors that Steve also encountered here by manually provide to pgpool ocf the paths to my correct system path. Also i have used the original ocf, generated by make, make install of pgpool-ha. So, instead of : <br><br>if [ "x$OCF_RESKEY_pgpoolconf" = 'x' ]; then<br> XX=$($PGPOOLCMD --help 2>&1 | grep ' config_file default path: ')<br> PGP_CONF=${XX# config_file default path: }<br>else<br> PGP_CONF=$OCF_RESKEY_pgpoolconf<br>i have : <br>if [ "x$OCF_RESKEY_pgpoolconf" = 'x' ]; then<br> PGP_CONF=/usr/local/etc/pgpool.conf<br>else<br> PGP_CONF=$OCF_RESKEY_pgpoolconf<br><br>and i did like this all my
config directives (i think that this could be overriden if you provide these params when importing ocf script to corosync).<br>Also do the fact that my pgpool scripts were run as root i have to modify the start and stop commands from : <br>su -c "$PGPOOL $PGPOOL_START_ARG" $PGPOOLUSER<br>to: <br>$PGPOOL $PGPOOL_START_ARG<br><br>and <br>RET=`su -c "$PGPOOL $PGPOOL_FORCE_STOP_ARG | grep ERROR " $PGPOOLUSER`<br>to<br>RET=`$PGPOOL $PGPOOL_FORCE_STOP_ARG | grep ERROR`<br><br>After all these modifications pgpool seems to work as expected.<br>Hope this will help someone<br><br>--- On <b>Tue, 4/24/12, Steven Bambling <i><smbambling@arin.net></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Steven Bambling <smbambling@arin.net><br>Subject: [pgpool-general: 379] Pacemaker CoroSync + PGPool-II<br>To: "pgpool-general@pgpool.net" <pgpool-general@pgpool.net><br>Date:
Tuesday, April 24, 2012, 3:45 PM<br><br><div id="yiv1614837915">
<div>
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.
<div><br>
</div>
<div>I've found an article here <a rel="nofollow" target="_blank" href="http://masteinhauser.github.com/blog/2011/09/24/pacemaker-pgpool2/">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 rel="nofollow" target="_blank" href="http://yum.postgresql.org/9.1/redhat/rhel-$releasever-$basearch">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></div>
<div><br>
</div>
<div>
<div>pgpool2_status() {</div>
<div> if [ ! -r "/<b>var/run/pgpool-II-91/pgpool.pid</b>" ]; then</div>
<div> return $OCF_NOT_RUNNING</div>
<div> fi</div>
<div> ps_info=$(ps ax | grep "pgpool" | grep $(cat <b>/var/run/pgpool-II-91/pgpool.pid</b>))</div>
</div>
<div><br>
</div>
<div>I used the following parameters to created the resource</div>
<div><br>
</div>
<div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
crm configure primitive pgPool ocf:heartbeat:pgpool2 <span style="color: rgb(220, 50, 47);">
\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(38, 139, 210);">
<span style="color: rgb(147, 161, 161);">params </span>pcp_admin_username<span style="color: rgb(147, 161, 161);"><b>=</b>postgres </span><span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_admin_password</span><b>=</b>password <span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(38, 139, 210);">
<span style="color: rgb(147, 161, 161);">params </span>pcp_admin_port<span style="color: rgb(147, 161, 161);"><b>=</b>9898
</span><span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_admin_host</span><b>=</b>localhost <span style="color: rgb(220, 50, 47);">
\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pgpool_bin</span><b>=</b>/usr/bin/pgpool <span style="color: rgb(220, 50, 47);">
\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_attach_node_bin</span><b>=</b>/usr/bin/pcp_attach_node
<span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_detach_node_bin</span><b>=</b>/usr/bin/pcp_detach_node
<span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_node_count_bin</span><b>=</b>/usr/bin/pcp_node_count
<span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">pcp_node_info_bin</span><b>=</b>/usr/bin/pcp_node_info
<span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(147, 161, 161);">
params <span style="color: rgb(38, 139, 210);">stop_mode</span><b>=</b>f <span style="color: rgb(220, 50, 47);">
\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(38, 139, 210);">
<span style="color: rgb(147, 161, 161);">params </span>auto_reconnect<span style="color: rgb(147, 161, 161);"><b>=</b>t
</span><span style="color: rgb(220, 50, 47);">\</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(38, 139, 210);">
<span style="color: rgb(220, 50, 47);">
<div style="margin: 0px; font: medium Helvetica; color: rgb(38, 139, 210);">
<span style="color: rgb(147, 161, 161);">params </span>fail_on_detached<span style="color: rgb(147, 161, 161);"><b>=</b>true </span><span style="color: rgb(220, 50, 47);">\</span></div>
</span></div>
<div style="margin: 0px; font: 12px Menlo; color: rgb(38, 139, 210);">
<span class="yiv1614837915Apple-style-span" style="color: rgb(147, 161, 161);">op monitor <span style="color: rgb(38, 139, 210);">
interval</span><b>=</b>1min</span></div>
</div>
<div style="margin: 0px; font: 12px Menlo;">
<font class="yiv1614837915Apple-style-span" color="#93a1a1"><br>
</font></div>
<div>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</div>
<div><br>
</div>
<div>
<div>============</div>
<div>Last updated: Tue Apr 24 08:31:08 2012</div>
<div>Last change: Tue Apr 24 08:02:31 2012 via cibadmin on <a rel="nofollow" target="_blank" href="http://pg1.stage.arin.net">
pg1.stage.arin.net</a></div>
<div>Stack: openais</div>
<div>Current DC: <a rel="nofollow" target="_blank" href="http://pg2.stage.arin.net">pg2.stage.arin.net</a> - partition with quorum</div>
<div>Version: 1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558</div>
<div>2 Nodes configured, 2 expected votes</div>
<div>2 Resources configured.</div>
<div>============</div>
<div><br>
</div>
<div>Online: [ <a rel="nofollow" target="_blank" href="http://pg1.stage.net">pg1.stage.net</a> <a rel="nofollow" target="_blank" href="http://pg2.stage.net">
pg2.stage.net</a> ]</div>
<div><br>
</div>
<div>ClusterIP<span class="yiv1614837915Apple-tab-span" style="white-space: pre;"> </span>(ocf::heartbeat:IPaddr2):<span class="yiv1614837915Apple-tab-span" style="white-space: pre;"><br></span>Started <a rel="nofollow" target="_blank" href="http://pg2.stage.net">pg2.stage.net</a></div>
<div><br>
</div>
<div>Failed actions:</div>
<div> pgPool_monitor_0 (node=pg1.stage.net, call=3, rc=2, status=complete): invalid parameter</div>
<div> pgPool_monitor_0 (node=pg2.stage.net, call=3, rc=2, status=complete): invalid parameter</div>
</div>
<div><br>
</div>
<div>When I look in the /var/log/cluster/corosync.log I see this error <b>Apr 24 08:23:48
<a rel="nofollow" target="_blank" href="http://pg1.stage.net">pg1.stage.net</a> lrmd: [28471]: WARN: Managed pgPool:monitor process 28484 exited with return code 2</b></div>
<div><b><br>
</b></div>
<div>Has anyone ran into a similar experience or have suggestions for a cluster solution with pgpool-II.</div>
<div><br>
</div>
<div>I know this is not 100% related to PGPool so I've also posted it to the pacemaker mailing list. </div>
<div><br>
</div>
<div>v/r</div>
<div><br>
</div>
<div>STEVE</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>pgpool-general mailing list<br><a ymailto="mailto:pgpool-general@pgpool.net" href="/mc/compose?to=pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div></blockquote></td></tr></table>