[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