[pgpool-general: 7336] Re: Force failover of pgpool watchdog leader

Tatsuo Ishii ishii at sraoss.co.jp
Thu Nov 12 16:00:04 JST 2020


> Hi all,
> 
> Is it possible to force the watchdog leader to switch to a different
> node in the cluster without stopping the current pgpool leader process
> entirely?
> 
> The reason I want to do this is to automate switchover when a host in
> my cluster is shut down or rebooted. Every host runs a database and a
> pgpool instance. So if the machine that is about to shut down is both
> pg primary and pgpool watchdog leader, both need to switch over to a
> different node. I can detach the pg primary to force a switchover, but
> if I then shutdown the pgpool leader (running on the same host), the
> database switchover is not completed correctly. When a different host
> is watchdog leader, the database switchover process continues when the
> shutdown host disappears and my cluster remains consistent.
> 
> My current solution is to stop pgpool if it currently is the watchdog
> leader, start it again, wait for some other node to pick up the leader
> status, trigger the database switchover and finally shutdown pgpool
> and postgres. This process is lengthy, complex and increases the
> amount of time the node is in a broken state.

Unfortunately there's no such a feature in watchdog. Maybe it's better
to add this request to the TODO list (for 4.3 development).

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list