[pgpool-general: 9043] Re: manually add a failed node back as a standby

[Bo Peng]

Hi,

You need to manually add the standby node to pgpool using the pcp_attach_node command.

https://www.pgpool.net/docs/latest/en/html/pcp-attach-node.html

Alternatively, you can enable "auto_failback" to automatically attach a healthy standby node.

  auto_failback = on

https://www.pgpool.net/docs/latest/en/html/runtime-config-failover.html#GUC-AUTO-FAILBACK

On Fri, 1 Mar 2024 09:20:20 -0700
Sbob <sbob at quadratum-braccas.com> wrote:

> All;
> 
> 
> I am using pgpool and repmgr
> 
> I did a failover that worked perfectly, then I reset the failed node to 
> be a standby via pg_basebackup and 'repmgr standby register' however 
> once I do that I can no longer connect to pgpool until I restart it, 
> even  a pcp_reload_config did not help
> 
> 
> Is it possible to inform pgpool of the new standby
> 
> 
> Thanks in advannce for any help
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/