Postgres Pro
Downloads
Home   >   mailing lists

Re: It is not documented that pg_promote can exit standby mode - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: It is not documented that pg_promote can exit standby mode
Date
Msg-id a0df06f3-4441-ce7f-582e-ee4c023ddf1e@oss.nttdata.com
Whole thread Raw
In response to It is not documented that pg_promote can exit standby mode  (ikedamsh <ikedamsh@oss.nttdata.com>)
Responses Re: It is not documented that pg_promote can exit standby mode  (Michael Paquier <michael@paquier.xyz>)
Re: It is not documented that pg_promote can exit standby mode  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 

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

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: ERROR: could not open file "pg_tblspc/ issue with replicationsetup.
Next
From: Michael Paquier
Date:
Subject: Re: It is not documented that pg_promote can exit standby mode