[pgpool-hackers: 3923] Re: [pgpool-general: 7588] Re: Promote specific backend to primary in streaming replication
ishii at sraoss.co.jp
Fri Jun 11 14:40:54 JST 2021
Hi Nathan, Umah,
> So "switchover" implies that pcp_promote exchanges the role of current
> primary and specified standby node. I think it's a little bit weak
> because if a follow primary command is not set, the primary will not
> become a standby: the status of primary will be down and the backend
> will remain running as primary. So "exchange" will not happen.
> If we employ "switchover", maybe we should stats in the doc something
> like: "without setting a follow primary command, pgpool will not
> exchange their role"?
>> @Ishii-san - I have read your email from the other day, and your subsequent email. I like the approach you are taking here, and very much support this new feature. I think from an end user perspective, having this functionality on the pcp_promote_node command makes a lot more sense than on pcp_detach_node - so I think the “new” way is much better. Thank you very much for your work on this!
You are welcome!
So this time I employ the idea to use "switchover" option, rather
"--really-promote" in my new patch. Unfortunately for the short option
name, we cannot use "-s" since it has been already used for other
purpose and I decided to use "-o".
Again, comments and suggestions are welcome!
SRA OSS, Inc. Japan
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 21482 bytes
Desc: not available
More information about the pgpool-hackers