Postgres Pro
Downloads
Home   >   mailing lists

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

From ikedamsh
Subject It is not documented that pg_promote can exit standby mode
Date
Msg-id de0068417a9f4046bac693cbcc00bdc9@oss.nttdata.com
Whole thread Raw
Responses Re: It is not documented that pg_promote can exit standby mode  (Fujii Masao <masao.fujii@oss.nttdata.com>)
change a function name in a comment correctly  (Masahiro Ikeda <ikedamsh@oss.nttdata.com>)
List pgsql-hackers
Tree view 
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.

Regards,
Masahiro Ikeda
Attachment

pgsql-hackers by date:

Previous
From: Hamid Akhtar
Date:
Subject: Re: Do we need to handle orphaned prepared transactions in the server?
Next
From: Michael Paquier
Date:
Subject: Re: ERROR: could not open file "pg_tblspc/ issue with replicationsetup.