Re: pg_rewind is not crash safe

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: pg_rewind is not crash safe
Дата
Msg-id 8604C380-E070-4853-A6FA-D20AFA0B918B@yandex-team.ru
обсуждение исходный текст
Ответ на pg_rewind is not crash safe  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers

> 5 авг. 2020 г., в 23:13, Heikki Linnakangas <hlinnaka@iki.fi> написал(а):
>
> A colleague of mine brought to my attention that pg_rewind is not crash safe. If it is interrupted for any reason, it
leavesbehind a data directory with a mix of data from the source and target images. If you're "lucky", the server will
startup, but it can be in an inconsistent state.  

FWIW we routinely encounter cases when after unsuccessful pg_rewind databases refuses to start with "contrecord
requested"message. 
I did not investigate this in detail yet, but I think it is a result of wrong redo recptr written to control file (due
tointerruption or insufficient present WAL segments). 

Best regards, Andrey Borodin.


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

Предыдущее
От: "Andrey M. Borodin"
Дата:
Сообщение: Re: Amcheck: do rightlink verification with lock coupling
Следующее
От: Noah Misch
Дата:
Сообщение: Re: public schema default ACL