[pgpool-general: 6975] Failover fails to start delegate IP

Wolf Schwurack wolf at uen.org
Wed Apr 15 01:16:07 JST 2020

I have 2 pgpool nodes - primary and standby using watchdog. When I stop pgpool on the primary to failover to the standby the delegate IP never starts. In the pgpool.log file on the standby I see
“I am the cluster leader node but we do not have enough nodes in cluster”
Now if a start pgpool on the primary, the delegate IP starts on the standby.  At the point the standby has the delegate IP, both nodes are up running pgpool. So I stop pgpool on the standby. Now the primary takes over and has the delegate IP.

So failing over to the standby, fails to get the delegate IP until the primary has pgpool running again. But the standby will failover to the primary and get the delegate IP without pgpool running on the standby.

Host OS = Ubuntu 18.04
PgPool version = 4.1.1 and tried on 4.1.0 same issue.

If I do the same test using PgPool version 4.0.5 the failover works both ways getting the delegate IP

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200414/0920cb4f/attachment.html>

More information about the pgpool-general mailing list