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

[Alexander Dorogensky]

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/89e21dbd/attachment.html>