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

Pierre Timmermans ptim007 at yahoo.com
Wed Mar 14 22:38:22 JST 2018

I think you can use the if_up_cmd and the if_down_cmd settings in pgpool config. 
When using a VIP, those config normally refer to a script on the system that will add the VIP (or remove) to the network interface.  But you can put anything you want into those scripts I guess.

    On Wednesday, March 14, 2018, 2:21:04 PM GMT+1, Alexander Dorogensky <amazinglifetime at gmail.com> wrote:  
 Yes, virtual IP is one way to configure HA but we're currently not using it.
The two nodes has watchdog enabled. And the watchdog on standby does detect when primary watchdog dies. Is there a callback that runs a script upon this kind of situation?
The idea is create a mechanism to automatically notify the administrator when one watchdog fails at minimum and to automatically restart pgpool on failed node at best.
On Tue, Mar 13, 2018 at 2:08 PM, Pierre Timmermans <ptim007 at yahoo.com> wrote:

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
http://www.pgpool.net/mailman/ listinfo/pgpool-general

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

More information about the pgpool-general mailing list