Re: Standby recovers records from wrong timeline

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: ants(at)cybertec(dot)at
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Standby recovers records from wrong timeline
Date: 2022-10-21 07:45:59
Message-ID: 20221021.164559.786703470971232819.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Thu, 20 Oct 2022 14:44:40 +0300, Ants Aasma <ants(at)cybertec(dot)at> wrote in
> My understanding is that backup archives are supposed to remain valid
> even after PITR or equivalently a lagging standby promoting.

Sorry, I was dim because of maybe catching a cold:p

On second thought. everything works fine if the first segment of the
new timeline is archived in this case. So the problem here is whether
recovery should wait for a known new timline when no segment on the
new timeline is available yet. As you say, I think it is sensible
that recovery waits at the divergence LSN for the first segment on the
new timeline before proceeding on the same timeline.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2022-10-21 08:12:45 Re: Standby recovers records from wrong timeline
Previous Message Kyotaro Horiguchi 2022-10-21 07:10:38 Crash after a call to pg_backup_start()