Re: standby promotion can create unreadable WAL

Поиск
Список
Период
Сортировка
Искать
От
Imseih (AWS), Sami
Тема
Re: standby promotion can create unreadable WAL
Дата
Msg-id
CBDD913D-E05C-45A3-B9D8-4EC3A3B10EE1@amazon.com
Ответ на
Список
Дерево обсуждения
standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL Nathan Bossart <nathandbossart@gmail.com>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL Dilip Kumar <dilipbalaut@gmail.com>
Re: standby promotion can create unreadable WAL Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL Dilip Kumar <dilipbalaut@gmail.com>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL Dilip Kumar <dilipbalaut@gmail.com>
Re: standby promotion can create unreadable WAL Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: standby promotion can create unreadable WAL Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL "Imseih (AWS), Sami" <simseih@amazon.com>
Re: standby promotion can create unreadable WAL Robert Haas <robertmhaas@gmail.com>
Re: standby promotion can create unreadable WAL "Imseih (AWS), Sami" <simseih@amazon.com>
Re: standby promotion can create unreadable WAL Dilip Kumar <dilipbalaut@gmail.com>
>    I agree. Testing StandbyMode here seems bogus. I thought initially
>    that the test should perhaps be for InArchiveRecovery rather than
>    ArchiveRecoveryRequested, but I see that the code which switches to a
>    new timeline cares about ArchiveRecoveryRequested, so I think that is
>    the correct thing to test here as well.

>    Concretely, I propose the following patch.

This  patch looks similar to the change suggested in 
https://www.postgresql.org/message-id/FB0DEA0B-E14E-43A0-811F-C1AE93D00FF3%40amazon.com
to deal with panics after promoting a standby.

The difference is the patch tests !ArchiveRecoveryRequested instead
of !StandbyModeRequested as proposed in the mentioned thread.


Thanks
--
Sami Imseih
Amazon Web Services

В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Robert Haas
Дата:
FAQ