[pgpool-general: 8945] Re: add / re-add a node to pgpool & repmgr

Tatsuo Ishii ishii at sraoss.co.jp
Mon Oct 16 12:00:36 JST 2023


> All;
> 
> 
> I have been testing pgpool and repmgr
> 
> I have a failover script that will promote a new node if needed and
> then unregister the node from the repmgr cluster
> 
> 
> My question is how to add a new node as a standby (or re-add a failed
> node as a standby)
> 
> I understand I can register the node with repmmgr once I setup
> streaming replication, but whats the best way to add it to pgpool in
> such a way that a pgpool restart still picks it up.
> 
> 
> Is it best to use pcp_attach_node?

Yes.

> or do I need to edit the
> pgpool.conf file and force a reload?

No, you don't need to.

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