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

[Pierre Timmermans]

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

    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.
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/20180314/e7236b7b/attachment.html>