[pgpool-general: 7592] Re: [pgpool-hackers: 3922] Re: Re: Promote specific backend to primary in streaming replication

Tatsuo Ishii 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!

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
-------------- next part --------------
A non-text attachment was scrubbed...
Name: promote_specified_node_v3.diff
Type: text/x-patch
Size: 21482 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210611/7be3311c/attachment-0001.bin>

More information about the pgpool-general mailing list