[pgpool-general: 4734] Re: Failover_command is not executed on standby server
Tatsuo Ishii
ishii at postgresql.org
Fri Jun 24 22:52:14 JST 2016
Works for me (without watchdog). When I shutdown standy node, it
triggers failover.
2016-06-24 22:46:28: pid 24757: LOG: reading and processing packets
2016-06-24 22:46:28: pid 24757: DETAIL: postmaster on DB node 1 was shutdown by administrative command
2016-06-24 22:46:28: pid 24757: LOG: received degenerate backend request for node_id: 1 from pid [24757]
2016-06-24 22:46:28: pid 24740: LOG: starting degeneration. shutdown host /tmp(11003)
2016-06-24 22:46:28: pid 24740: LOG: Restart all children
2016-06-24 22:46:28: pid 24740: LOG: execute command: /home/t-ishii/work/pgpool-II/current/aaa/etc/failover.sh 1 /tmp 11003 /home/t-ishii/work/pgpool-II/current/aaa/data1 0 0 /tmp 0 11002 /home/t-ishii/work/pgpool-II/current/aaa/da
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hello.
> I have two nodes with postgresql with streaming replication and pgpool with
> watchdog.
>
> Using pgpool version 3.4.7 (tataraboshi):
> - If postgres service of standby server is down, then failover_command is
> not executed (no lines showed in pgpool log file).
> - If postgres service of primary server is down, then failover_command is
> executed (it is showed in pgpool log file).
>
> Using pgpool version 3.4.6 (tataraboshi):
> - If postgres service of standby server is down, then failover_command is
> executed (it is showed in pgpool log file).
> - If postgres service of primary server is down, then failover_command is
> executed (it is showed in pgpool log file).
>
> Why does failover_command is not executed with version 3.4.7 when postgres
> service in standby server is down?
>
> Thanks in advance.
More information about the pgpool-general
mailing list