Re: Recovery at replica stuck because recovery incorrectly trusts an old high-water mark - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Recovery at replica stuck because recovery incorrectly trusts an old high-water mark
Date
Msg-id 867adbba98743e09428e4051f5b9013b4f4f10e1.camel@j-davis.com
Whole thread
List pgsql-hackers
On Sun, 2026-09-13 at 16:30 +0300, Konstantin Knizhnik wrote:
> A physical standby can get stuck forever if local pg_wal contains a
> corrupt record that walreceiver has already reported as flushed.
> What happens:

I can't help but ask: how did it get corrupted? Is it also corrupted on
the primary? What kinds of failures can cause this situation?

There seems to already be some kind of policy that we should try to re-
fetch bad records. Are you extending that policy or filling in an
implementation gap?

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_*_advice: tsv load failure, etc.
Next
From: Masahiko Sawada
Date:
Subject: Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation