Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Paquier
Subject Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing
Date
Msg-id CAB7nPqQgBjJXk_Zu16PDc9iQpGqnakScE+-TP8-eEFYiru=NTA@mail.gmail.com
Whole thread Raw
In response to Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing  (John Lumby <johnlumby@hotmail.com>)
Responses Re: how to switch old replication Master to new Standby after promoting old Standby - pg_rewind log file missing  (John Lumby <johnlumby@hotmail.com>)
List pgsql-general
Tree view 
On Tue, Mar 15, 2016 at 5:14 PM, John Lumby <johnlumby@hotmail.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)
pg_rewind begins scanning WAL records not at the point where WAL
forked, but from the previous checkpoint record before WAL forked.
--
Michael

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_dump crashing
Next
From: otheus uibk
Date:
Subject: How to Qualifying or quantify risk of loss in asynchronous replication