Re: Pg_rewind cannot load history wal - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Pg_rewind cannot load history wal
Date
Msg-id EE81B078-37FE-43B3-8083-0BC78ACF0699@thebuild.com
Whole thread Raw
In response to Re: Pg_rewind cannot load history wal  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Pg_rewind cannot load history wal
List pgsql-general
> On Aug 4, 2018, at 06:13, Michael Paquier <michael@paquier.xyz> wrote:
>
> Well, since its creation we have the tool behave this way.  I am not
> sure either that we can have pg_rewind create a checkpoint on the source
> node each time a rewind is done, as it may not be necessary, and it
> would enforce WAL segment recycling more than necessary, so if we were
> to back-patch something like that I am pretty much convinced that we
> would get complains from people already using the tool, with existing
> failover flows which are broken.

Would having pg_rewind do a checkpoint on the source actually cause anything to break, as opposed to a delay while the
checkpointcompletes?  The current situation can create a corrupted target, which seems far worse than just slowing down
pg_rewind.

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-general by date:

Previous
From: C GG
Date:
Subject: PANIC: could not open critical system index 2662
Next
From: Tom Lane
Date:
Subject: Re: PANIC: could not open critical system index 2662