Sir,<br><br>I am using heartbeat-pacemaker for my two node postgresql cluster with slony database replication. I am using the init script for the postgresql coz my ocf script is not working. Somehow I manage with my init script.<br>
<br>My packages are:<br><br clear="all">heartbeat 2.99.2+sles11r9-5ubuntu1 <br>heartbeat-common 2.99.2+sles11r9-5ubuntu1 <br>
heartbeat-common-dev 2.99.2+sles11r9-5ubuntu1 <br>heartbeat-dev 2.99.2+sles11r9-5ubuntu1<br>libheartbeat2 2.99.2+sles11r9-5ubuntu1<br>libheartbeat2-dev 2.99.2+sles11r9-5ubuntu1 <br>
pacemaker-heartbeat 1.0.5+hg20090813-0ubuntu4<br>pacemaker-heartbeat-dev 1.0.5+hg20090813-0ubuntu4<br><br>My <a href="http://ha.cf" target="_blank">ha.cf</a> file and crm.xml file are attached with in.<br>
<br>
My crm file :<br>_______________________________________________________________<br>node $id="3952b93e-786c-47d4-8c2f-a882e3d3d105" node2 \<br> attributes standby="off"<br>node $id="ac87f697-5b44-4720-a8af-12a6f2295930" node1 \<br>
attributes standby="off"<br><span style="background-color: rgb(255, 255, 51);">primitive pgsql lsb:postgresql-8.4 \</span><br style="background-color: rgb(255, 255, 51);"><span style="background-color: rgb(255, 255, 51);"> meta target-role="Started" resource-stickness="inherited" \</span><br style="background-color: rgb(255, 255, 51);">
<span style="background-color: rgb(255, 255, 51);"> op monitor interval="15s" timeout="25s" on-fail="standby"</span><br>primitive slony-fail lsb:slony_failover \<br> meta target-role="Started"<br>
primitive slony-fail2 lsb:slony_failover2 \<br> meta target-role="Started"<br>primitive vir-ip ocf:heartbeat:IPaddr2 \<br> params ip="192.168.10.10" nic="eth0" cidr_netmask="24" broadcast="192.168.10.255" \<br>
op monitor interval="15s" timeout="25s" on-fail="standby" \<br> meta target-role="Started"<br><span style="background-color: rgb(255, 255, 51);">clone pgclone pgsql \</span><br style="background-color: rgb(255, 255, 51);">
<span style="background-color: rgb(255, 255, 51);"> meta notify="true" globally-unique="false" </span>interleave="true" target-role="Started"<br>colocation ip-with-slony inf: slony-fail vir-ip<br>
colocation ip-with-slony2 inf: slony-fail2 vir-ip<br>order ip-b4-slony2 inf: vir-ip slony-fail2<br>order slony-b4-ip inf: vir-ip slony-fail<br>property $id="cib-bootstrap-options" \<br> dc-version="1.0.5-3840e6b5a305ccb803d29b468556739e75532d56" \<br>
cluster-infrastructure="Heartbeat" \<br> no-quorum-policy="ignore" \<br> stonith-enabled="false" \<br> last-lrm-refresh="1266563445"<br>rsc_defaults $id="rsc-options" \<br>
resource-stickiness="INFINITY"<br><br>__________________________________________________________________________<br>-- <br>My <a href="http://ha.cf" target="_blank">ha.cf</a> file<br><br>-----------------------------------------------------------------------<br>
autojoin none<br>keepalive 2<br>deadtime 15<br>warntime 5<br>initdead 64<br>udpport 694<br>bcast eth0<br>auto_failback off<br>node node1<br>node node2<br>crm respawn<br>use_logd yes<br>__________________________________________________<br>
<br>The configuration is working fine for me. When I stop the postgresql service in active machine , it will go to standby and resource is moved to other machine. But the issues is that my postgresql log file is getting filled with <br>
<br><span style="background-color: rgb(255, 255, 51);">2010-02-19 13:19:30 IST LOG: incomplete startup packet</span><br style="background-color: rgb(255, 255, 51);"><span style="background-color: rgb(255, 255, 51);">2010-02-19 13:19:45 IST LOG: incomplete startup packet</span><br style="background-color: rgb(255, 255, 51);">
<span style="background-color: rgb(255, 255, 51);">2010-02-19 13:20:00 IST LOG: incomplete startup packet</span><br style="background-color: rgb(255, 255, 51);"><span style="background-color: rgb(255, 255, 51);">......</span><br style="background-color: rgb(255, 255, 51);">
<br>messages like this. I googled and I fount that my pgsql monitor is is the cause for this. You can see that the message is given at the same instant as the monitor interval.<br><br>Is there any way to get rid of this??<br>
<br>Regards,<br><br>Jayakrishnan. L<br><br>Visit: <a href="http://www.jayakrishnan.bravehost.com" target="_blank">www.jayakrishnan.bravehost.com</a><br><br>