Re: Questions about the continuity of WAL archiving

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Questions about the continuity of WAL archiving
Дата
Msg-id CAKAnmmJPGgEp2kKPomhq7P=GUA5HD1eOaP5X+7c68gm5f4YVqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Questions about the continuity of WAL archiving  (px shi <spxlyy123@gmail.com>)
Ответы Re: Questions about the continuity of WAL archiving
Список pgsql-general
Дерево обсуждения
There is a scenario: the current timeline of the PostgreSQL primary node is 1, and the latest WAL file is 100. The standby node has also received up to WAL file 100. However, the latest WAL file archived is only file 80. If the primary node crashes at this point and the standby is promoted to the new primary, archiving will resume from file 100 on timeline 2. As a result, WAL files from 81 to 100 on timeline 1 will be missing from the archive.
Is there a good solution to prevent this situation?

I'm still not clear on what the problem here is, other than your archiving not keeping up. The best solution to that is:


Yes, you would lost some ability for easy PITR for 80-100, but could still be done by resurrecting your crashed primary, or carefully grabbing from the replica before they get recycled. You can set archive_mode=always on the replicas to help with this.
 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

В списке pgsql-general по дате отправления: