[pgpool-general: 7684] Virtual IP is not following the Primary Postgres

Luca Maranzano liuk001 at gmail.com
Tue Sep 7 23:09:09 JST 2021


Hi all,

we setup a 3 nodes cluster with PGPool-II version 4.2.3 like described here:

https://www.pgpool.net/docs/latest/en/html/example-cluster.html

Tonight the primary node failed for network problems and failover occurred,
BUT we found that the Virtual IP was moved not on the new Primary Postsgres
but on the Standby one.

Since the Virtual IP is used for client connections to the Writable
Postgres, the clients were actually connecting to a Read-Only instance.

Shouldn't the Virutal IP get migrated ONLY on the node that has Primary
Role?

Thanks in advance.
Regards
Luca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210907/0031ab0b/attachment.htm>


More information about the pgpool-general mailing list