Re: PostgreSQL Timeline Issue After Switchover with Pacemaker - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: PostgreSQL Timeline Issue After Switchover with Pacemaker
Date
Msg-id d42470b8ffe06f9622f357b522161cd9b8ec25af.camel@cybertec.at
Whole thread Raw
Responses RE: PostgreSQL Timeline Issue After Switchover with Pacemaker
List pgsql-admin
On Fri, 2025-01-31 at 09:09 +0900, di.liu@japannext.co.jp wrote:
> Why, after a full backup restore, did the standby still look for the wrong timeline?
> Is there a file or setting that records the timeline information?

It is hard to say what exactly happened, since I don't know your exact setup,
but very likely a standby server got promoted, started a new timeline 8 and
archived the corresponding history file.  But somehow the rest of the cluster
didn't follow that promotion.  Now upon every restore attempt, the history
file gets fetched from the WAL archive and causes confusion.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: postgresql support for diacritical character sets?
Next
From: Bo Guo
Date:
Subject: How to increase the max query history stored