[pgpool-general: 5413] Re: handling network failures

Tatsuo Ishii ishii at sraoss.co.jp
Sat Apr 1 10:50:46 JST 2017


Do you have any suggestion on this?

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

> 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

More information about the pgpool-general mailing list