Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_ctl promote wait - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_ctl promote wait
Date
Msg-id CAB7nPqRWT0TDsnTFgWgWOsFRO7VQouzn6gh=5r+VqnUOgLYtjg@mail.gmail.com
Whole thread Raw
In response to Re: pg_ctl promote wait  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: pg_ctl promote wait
List pgsql-hackers
Tree view 
On Mon, Feb 29, 2016 at 4:28 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> I would suggest using
> $node_standby->poll_query_until('SELECT pg_is_in_recovery()') to
> validate the end of the test.

Meh. SELECT NOT pg_is_in_recovery(). This will wait until the query
returns true.
-- 
Michael

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_ctl promote wait
Next
From: Amit Langote
Date:
Subject: Re: Proposal: "Causal reads" mode for load balancing reads without stale data