Re: PostgreSQL Timeline Issue After Switchover with Pacemaker

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 2025-01-31 at 09:09 +0900, di.liu@xxxxxxxxxxxxxxx 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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux