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.
+1 >> > 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. Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers