Re: PostgreSQL Timeline Issue After Switchover with Pacemaker

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: di(dot)liu(at)japannext(dot)co(dot)jp, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL Timeline Issue After Switchover with Pacemaker
Date: 2025-01-31 06:37:00
Message-ID: d42470b8ffe06f9622f357b522161cd9b8ec25af.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2025-01-31 at 09:09 +0900, di(dot)liu(at)japannext(dot)co(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bo Guo 2025-01-31 09:15:25 How to increase the max query history stored
Previous Message Somnath Som 2025-01-31 05:12:18 Backup Issue for pg_basebackup