Re: pg_ctl promote wait - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_ctl promote wait
Date
Msg-id 56D39F40.4060802@gmx.net
Whole thread Raw
In response to Re: pg_ctl promote wait  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_ctl promote wait
List pgsql-hackers
On 2/19/16 3:09 PM, 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.

Here is a patch set around that idea.

The subsequent discussion mentioned that there might still be a window
between end of waiting and when read-write queries would be accepted.  I
don't know how big that window would be in practice and would be
interested in some testing and feedback.

Attachment

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Improve error handling in pltcl
Next
From: Joe Conway
Date:
Subject: Re: Proposal: SET ROLE hook