[pgpool-general: 9030] Re: force a pgpool re-scan?

Tatsuo Ishii ishii at sraoss.co.jp
Tue Feb 27 13:38:38 JST 2024


> we are setting up pgpool instances for a primary site and for a DR
> site. To start with the DR site pgpool instance will have no writable
> nodes but onle a set of hot standby's
> 
> if we failover to the DR site then we will promote one of the postgres
> nodes in DR but we will not have an actual db failure so the DR pgpool
> instance will not execute it's failover script.
> 
> 
> Is there a method to force pgpool to re-scan the db nodes and identify
> the writable node?

There's no re-scan method except restarting pgpool or
failover. However you could use pcp_promote_node command to teach
pgpool which is the new primary node.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp



More information about the pgpool-general mailing list