On Thu, Feb 18, 2016 at 5:45 PM, Simon Riggs <si...@2ndquadrant.com> wrote:
> On 18 February 2016 at 08:33, Andres Freund <and...@anarazel.de> wrote:
>> Hi,
>> On 2016-02-17 21:47:50 -0500, Peter Eisentraut wrote:
>> > It would be nice if pg_ctl promote supported the -w (wait) option.


>> > How could pg_ctl determine when the promotion has finished?
>> How about looking into pg_control? ControlFileData->state ought to have
>> the correct information.
> +1

One concern is that there can be a "time" after the pg_control's state
is changed to DB_IN_PRODUCTION and before the server is able to
start accepting normal (not read-only) connections. So if users try to
start write transaction just after pg_ctl promote -w ends, they might
get an error because the server is still in recovery, i.e., the startup
process is running.


Fujii Masao

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to