Re: PostgreSQL Failback without rebuild

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)lisasoft(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL Failback without rebuild
Date: 2014-02-07 07:24:49
Message-ID: CAB7nPqTYTyuOj5258Wd0SKNORhRv2MDpBTEq9YXLPCyuW6VpZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 7, 2014 at 3:02 PM, James Sewell <james(dot)sewell(at)lisasoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Albe Laurenz 2014-02-07 07:41:26 Re: PostgreSQL Failback without rebuild
Previous Message Amit Kapila 2014-02-07 07:05:05 Re: Inconsistency between pg_stat_activity and log_duration