Re: PostgreSQL Timeline Issue After Switchover with Pacemaker

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: PostgreSQL Timeline Issue After Switchover with Pacemaker
Дата
Msg-id d42470b8ffe06f9622f357b522161cd9b8ec25af.camel@cybertec.at
обсуждение исходный текст
Ответы RE: PostgreSQL Timeline Issue After Switchover with Pacemaker
Список 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 по дате отправления: