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

[Pierre Timmermans]

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.
Pierre 

    On Tuesday, March 13, 2018, 5:15:29 PM GMT+1, Alexander Dorogensky <amazinglifetime at gmail.com> wrote:  
 
 Hi,
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
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180313/5f6153c0/attachment.html>