Re: It is not documented that pg_promote can exit standby mode

Fujii Masao <masao.fujii@oss.nttdata.com>

From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: ikedamsh <ikedamsh@oss.nttdata.com>, pgsql-hackers@postgresql.org
Date: 2020-04-17T04:40:02Z
Lists: pgsql-hackers

On 2020/04/17 13:11, ikedamsh wrote:
> Hi,
> 
> The document(high-availability.sgml) says that there are only two ways to exit standby mode.
> 
>  26.2.2. Standby Server Operation
>  Standby mode is exited and the server switches to normal operation when pg_ctl promote is run or a trigger file is found (promote_trigger_file).
> 
> But there is another way, by calling pg_promote function.
> I think we need to document it, doesn't it?
> 
> I attached a patch. Please review and let me know your thoughts.

Thanks for the report and the patch! It looks good to me.
Barring any objection, I will commit this patch.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



Commits

  1. Fix function name in comment.

  2. Mention pg_promote() as a method to trigger promotion in documentation.