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
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 |