<div dir="ltr">Hey, <div><br></div><div>I am using PGpool on an AWS instance with the following settings:</div><div><br></div><div><div><font face="monospace, monospace">backend_flag0 = 'ALLOW_TO_FAILOVER'<br></font></div><div><font face="monospace, monospace">backend_flag1 = 'ALLOW_TO_FAILOVER'<br></font></div><div><font face="monospace, monospace">failover_command = ''</font></div><div><font face="monospace, monospace">failback_command = ''</font></div><div><font face="monospace, monospace">fail_over_on_backend_error = off</font><br></div><div><br></div><div>I am managing failovers from an external product (EDB Enterprise Failover Manager). This seems to work well most of the time.</div><div><br></div><div>Sometimes I get the master node failing because of the AWS network flaking out on me, this works as expected and I get into the following state:</div><div><br></div><div><div><font face="monospace, monospace">postgres=# show pool_nodes;</font></div><div><font face="monospace, monospace"> node_id | hostname | port | status | lb_weight | role</font></div><div><font face="monospace, monospace">---------+--------------+------+--------+-----------+---------</font></div><div><font face="monospace, monospace"> 0 | 10.51.9.174 | 5432 | 3 | 0.500000 | primary</font></div><div><font face="monospace, monospace"> 1 | 10.51.10.173 | 5432 | 2 | 0.500000 | standby</font></div><div><font face="monospace, monospace">(2 rows)</font></div></div><div><br></div><div>My question is, is there any way in PGPool to automatically re-enable the primary node when it shows up again? If it *really* went down then my EFM would fail it over (which runs pcp_promote_node) - so I just want it to enable it when it shows up again. I can't explain why EFM seems to be more fault tolerant than PGPool - but I'm ignoring that for now.</div><div><br></div><div>I tried using <span style="font-family:monospace,monospace">DISALLOW_TO_FAILOVER </span><font face="arial, helvetica, sans-serif">, but this removes any way of disabling a single node and stops all PGPool access when I stop the standby node. This won't work for me. I need to be able to perform the following operations:</font></div><div><ul><li><font face="arial, helvetica, sans-serif">promote a node in PGPool to master (I use pcp_promote_node currently)</font></li><li><font face="arial, helvetica, sans-serif">disable a node in PGPool (I use pcp_detach_node currently)</font></li><li><font face="arial, helvetica, sans-serif">enable a node I have disabled (I use pcp_enable_node currently)</font></li><li><font face="arial, helvetica, sans-serif">Operate on just the master node</font></li><li><font face="arial, helvetica, sans-serif">Operate on just the slave node (read only)</font></li></ul><div><font face="arial, helvetica, sans-serif">I can't seem to find a way to hit all these and still have a functioning environment.</font></div></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">I'm getting the feeling that maybe I can't get all this from PGPool, but any help would be appreciated. I'm on PGPool 3.3.1</font></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">Cheers,</font></div><div><br></div><div><div class="gmail_signature"><div style="color:rgb(184,39,106);font-weight:bold;font-style:normal;font-variant:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Arial,Helvetica,sans-serif">
<br>
<span style="color:rgb(50,59,98)">James Sewell,</span><br>
<span style="color:rgb(169,169,169)"><span style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Arial,Helvetica,sans-serif">PostgreSQL Team Lead / Solutions Architect </span></span><br>
<span style="color:rgb(169,169,169)">______________________________________</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-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:12px;line-height:20px;font-family:Arial,Helvetica,sans-serif;color:rgb(64,64,64);margin:0px">
<span style="color:rgb(169,169,169)">Level 2, 50 Queen St, Melbourne VIC 3000</span><br>
<br>
<strong>P </strong><span style="color:rgb(169,169,169)"><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:rgb(169,169,169)">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:rgb(169,169,169)"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8099</span></span></div>
<div style="padding-top:8px">
</div></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>