Re: PostgreSQL Failback without rebuild - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: PostgreSQL Failback without rebuild
Date
Msg-id CAB7nPqTYTyuOj5258Wd0SKNORhRv2MDpBTEq9YXLPCyuW6VpZg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Failback without rebuild  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: PostgreSQL Failback without rebuild  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-hackers
On Fri, Feb 7, 2014 at 3:02 PM, James Sewell <james.sewell@lisasoft.com> wrote:
Node A could get ahead even if it has been shut down cleanly BEFORE the promotion?
I'd always assumed if I shut down the master the slave would be at the same point after shutdown - is this incorrect?
Yes and no. A node will wait at shutdown until all the *connected* slaves have flushed necessary WALs to disk. But if the slave is not connected at the moment of shutdown, it might not be the case.
--
Michael

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Inconsistency between pg_stat_activity and log_duration
Next
From: Albe Laurenz
Date:
Subject: Re: PostgreSQL Failback without rebuild