Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing

From: John Lumby <johnlumby(at)hotmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Cc: "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, "adrian(dot)klaver(at)aklaver(dot)com" <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing
Date: 2016-03-15 17:43:46
Message-ID: COL131-W804D45E77B0D0FB1EF08B1A3890@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Date: Tue, 15 Mar 2016 17:21:50 +0100
> Subject: Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing
> From: michael(dot)paquier(at)gmail(dot)com
> To: johnlumby(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org; oleksandr(dot)shulgin(at)zalando(dot)de; adrian(dot)klaver(at)aklaver(dot)com
>
> On Tue, Mar 15, 2016 at 5:14 PM, John Lumby <johnlumby(at)hotmail(dot)com> wrote:
>> But my question is, given that the divergence point was 2B000060,
>> why is it looking for a file earlier than that?
>
> (please do not top-post, this is annoying as it breaks the logic of the thread)

sorry, ok

> pg_rewind begins scanning WAL records not at the point where WAL
> forked, but from the previous checkpoint record before WAL forked.

In that case,  I wonder if it would be useful to extend the replication_slots concept
to be able to specify to retain all WALs back to
 "previous checkpoint before most recent timeline switch"
in order to guarantee that pg_rewind shall always be able to find the ones it needs
in source without requiring archiving and archive-retrieval?

> --
> Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2016-03-15 17:59:26 Re: pg_dump crashing
Previous Message otheus uibk 2016-03-15 17:26:49 How to Qualifying or quantify risk of loss in asynchronous replication