[pgpool-general: 6485] Re: Kind of notify about failover

[Bo Peng]

Hi,

On Wed, 27 Mar 2019 12:08:04 +0300
Dmitry Medvedev <dm.dm.medvedev at gmail.com> wrote:

> Hello to everyone. A couple of days I've spent trying to understand how
> pgpool-II works.
> 
> Tell me, please, is there any kind of notification when failover event
> occurs, except writing string to syslog?

No notification except output to log.
But you can check the "status" and "role" of backend nodes by using "show pool_nodes".
If the "status" or "role" is changed, failover occured.

http://www.pgpool.net/docs/latest/en/html/sql-show-pool-nodes.html
-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan