Re: pg_ctl promote wait - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_ctl promote wait
Date
Msg-id 27607.1455914005@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_ctl promote wait  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2016-02-19 15:09:58 -0500, Tom Lane wrote:
>> I see no need for an additional mechanism.  Just watch pg_control until
>> you see DB_IN_PRODUCTION state there, then switch over to the same
>> connection probing that "pg_ctl start -w" uses.

> That's afaics not sufficient if the standby was using hot standby, as
> that'll let -w succeed immediately, no?

Oh, now I get Fujii-san's point.  Yes, that wouldn't prove anything
about whether you could do a write transaction immediately.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_ctl promote wait
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: PL/Pythonu - function ereport