Re: pgsql: Fix WAL replay in presence of an incomplete record

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Fix WAL replay in presence of an incomplete record
Дата
Msg-id 364321.1636071230@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: pgsql: Fix WAL replay in presence of an incomplete record  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
[ I'm working on the release notes ]

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Fix WAL replay in presence of an incomplete record
> ...
> Because a new type of WAL record is added, users should be careful to
> upgrade standbys first, primaries later. Otherwise they risk the standby
> being unable to start if the primary happens to write such a record.

Is there really any point in issuing such advice?  IIUC, the standbys
would be unable to proceed anyway in case of a primary crash at the
wrong time, because an un-updated primary would send them inconsistent
WAL.  If anything, it seems like it might be marginally better to
update the primary first, reducing the window for it to send WAL that
the standbys will *never* be able to handle.  Then, if it crashes, at
least the WAL contains something the standbys can process once you
update them.

Or am I missing something?

            regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: WIP: expression evaluation improvements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: inefficient loop in StandbyReleaseLockList()