[pgpool-general: 5993] Re: When pgpool on primary node dies

Pierre Timmermans ptim007 at yahoo.com
Wed Mar 14 04:08:08 JST 2018

If you set-up the two pgpool nodes in watch-dog mode then yes, the surviving pgpool node will detect when the other node is stopped (via a heartbeat mechanism). 
In watchdog mode each pgpool node knows about all the others, one of them is elected as primary. The primary pgpool node acquires the VIP (virtual IP aka delegate_ip in pgpool names).  So this is really about making pgpool itself highly available, not to be confused with postgres replication.
The pgpool instances can be on the same servers as postgres or they can be on other servers.

    On Tuesday, March 13, 2018, 5:15:29 PM GMT+1, Alexander Dorogensky <amazinglifetime at gmail.com> wrote:  
I have a primary/standby configuration with streaming replication.There's two nodes and each node has pgpool.
When I kill pgpool on primary, does standby gets notified?
This is not a failover scenario and the failover script doesn't get executed._______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180313/5f6153c0/attachment.html>

More information about the pgpool-general mailing list