Re: help with startup slave after pg_rewind - Mailing list pgsql-general

From Michael Paquier
Subject Re: help with startup slave after pg_rewind
Date
Msg-id 20180921000902.GE1338@paquier.xyz
Whole thread Raw
In response to help with startup slave after pg_rewind  (Dylan Luong <Dylan.Luong@unisa.edu.au>)
List pgsql-general
On Wed, Sep 19, 2018 at 10:29:44PM +0000, Dylan Luong wrote:
> After promoting slave to master, I completed a pg_rewind of the slave
> (old master) to the new master. But when I try to start the slave I am
> getting the following error.
>
> I tried to run pg_rewind again, but now it says I cannot do it as its
> already same timeline.

What did pg_rewind tell you after the first run?  If you remove the set
of WAL segments on the rewound instance and let it replay only segments
from the archive, are you able to get past?

There is an inconsistency in the WAL records you are trying to replay.
In this case a contrecord refers to a WAL record split across multiple
pages.  The WAL reader is expecting one, and cannot find it.  And that's
not normal.  My bet is that something is wrong in your failover flow
which you think is right.  It is hard to get that right.
--
Michael

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of Memory
Next
From: Stephen Cook
Date:
Subject: Re: Code of Conduct