<div dir="ltr">Hello All,<div><br></div><div>I have a load balancer in front of a pair of pgpool nodes (3.3.1), in front of a pair of PostgreSQL nodes (9.3) which are configured as a streaming pair. I am running on RHEL.</div>
<div><br></div><div>I am using another HA tool to manage the failover between the Postgres nodes, and the load is spread between the pgpool nodes with inactive nodes being taken out of the load balanced pool.</div><div><br>
</div><div>Do I need watchdog in this case? I have seen reports that pgpool still synchronises useful information using this connection, but can't find what this information is?</div><div><br></div><div>If I did use watchdog, which settings would I need in this limited case?</div>
<div><br></div><div>Also is there a pcp command which I can use to tell pgpool that a new node is master, but not actually promote it (this would have happened already)? Does pcp_promote_node do this when no promotion script is provided?</div>
<div><br></div><div>Thanks for the help.</div><div><br></div><div>Cheers,</div><div><div><div style="color:#b8276a;font:bold 14px Arial,Helvetica,sans-serif">
<br>
<span style="color:#323b62">James Sewell,</span><br><span style="color:#a9a9a9"><span style="font:12px Arial,Helvetica,sans-serif">Solutions Architect </span></span><br>
<span style="color:#a9a9a9">______________________________________</span><br>
</div>
<img alt="" src="http://www.lisasoft.com/sites/lisasoft/files/u1/logo1.jpg" style="margin:0px;width:153px;height:50px"><br>
<div style="font:normal 12px/20px Arial,Helvetica,sans-serif;color:#404040;margin:0">
<span style="color:#a9a9a9">Level 2, 50 Queen St, Melbourne VIC 3000</span><br>
<br>
<strong>P </strong><span style="color:#a9a9a9"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8000</span></span><span style="color:rgb(169,169,169)"> </span><strong> </strong><span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>W</strong></span></span> <a style="color:rgb(64,64,64);margin:2px 0px;text-decoration:none"><span style="color:#a9a9a9">www.lisasoft.com</span></a> <span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>F </strong></span></span><span style="color:#a9a9a9"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8099</span></span></div>
<div style="padding-top:8px">
</div></div>
</div></div>
<br>
<p><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14.545454025268555px;background-color:rgb(255,255,255)"><hr><font size="1" color="Gray" face="Arial">The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.</font></div></p>