Re: Timeline switching with partial WAL records can break replica recovery - Mailing list pgsql-hackers

From Artem Gavrilov
Subject Re: Timeline switching with partial WAL records can break replica recovery
Date
Msg-id CAFPkQKwvfW=My5ET1MxZhwH1bmdHRneBna8q7EQqSUJac1X-2w@mail.gmail.com
Whole thread Raw
In response to Re: Timeline switching with partial WAL records can break replica recovery  (Alena Vinter <dlaaren8@gmail.com>)
List pgsql-hackers
Could this be avoided by having the standby check the WAL archive before promotion?

I'm afraid we can't say anything about how archiving works for the whole cluster. It's quite possible that archiving configured only on primary or primary and secondary use different archive locations or maybe you have archive_command but not restore_command configured, etc... 

Maybe we can add an exception and let the new timeline start after incomplete contrecord? Most likely it will cause problems that I'm unaware of, but it seems we can handle such record in both timelines.

--

Artem Gavrilov

Senior Software Engineer, Percona

artem.gavrilov@percona.com

percona.com

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Buffer locking is special (hints, checksums, AIO writes)
Next
From: Matheus Alcantara
Date:
Subject: Re: PL/Python initialization cleanup