[pgpool-general: 5303] Re: About failover execution and master node detection

Tatsuo Ishii ishii at sraoss.co.jp
Tue Feb 7 12:50:59 JST 2017


> I am Reading the pgpool documentation and i have a doubt related to failover
> and selecting a new master node. 
> 
>  
> 
> I want to create a cluster with more than 2 nodes for instance 3 nodes. The
> question is when the backend shuts down, the new primary selected by pgpool
> and sended to the failover command is the closest node to previous master,
> in terms of replication delay?

Probably you are misunderstanding. Pgpool-II does *not* automatically
choose new primary. It's totally up to you how to select the new
primary node in the failover command script. In other word, the logic
to choose the new primary node should be explicitly coded in the
failover command script.

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