[pgpool-general: 5410] handling network failures

[Travis Kirstine]

I have pgpool 3.4 running in watchdog / load balancing  mode with two backend postgresql nodes and have run into an issue when there is a brief network outage (switch reboot).

When an outage occurs the result would be:

The standby pgpool node will promote itself to active and execute a failover command
The active pgpool node will remain active and execute a failover command
Both postgresql nodes will be running as master
Both pgpool nodes will hold the delegate ip

Was this issue addressed in this?
http://www.pgpool.net/pipermail/pgpool-committers/2016-January/002926.html

If not, how is this this handled?

Thanks

Travis Kirstine
Project Supervisor
140 Renfrew Drive, Suite 100
Markham, Ontario L3R 6B3 Canada
[cid:image002.png at 01D2AA27.51B79D40]<http://www.firstbasesolutions.com/>
T: 905.477.3600 Ext 267 | C: 647

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/cc36b281/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3026 bytes
Desc: image001.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/cc36b281/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5584 bytes
Desc: image002.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/cc36b281/attachment-0001.png>