Re: Add recovery to pg_control and remove backup_label

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add recovery to pg_control and remove backup_label
Дата
Msg-id ZVvxKDVUH-kvW_qD@paquier.xyz
обсуждение исходный текст
Ответ на Re: Add recovery to pg_control and remove backup_label  (Andres Freund <andres@anarazel.de>)
Ответы Re: Add recovery to pg_control and remove backup_label  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Mon, Nov 20, 2023 at 12:37:46PM -0800, Andres Freund wrote:
> Given that, I wonder if what we should do is to just add a new field to
> pg_control that says "error out if backup_label does not exist", that we set
> when creating a streaming base backup

That would mean that one still needs to take an extra step to update a
control file with this byte set, which is something you had a concern
with in terms of compatibility when it comes to external backup
solutions because more steps are necessary to take a backup, no?  I
don't quite see why it is different than what's proposed on this
thread, except that you don't need to write one file to the data
folder to store the backup label fields, but two, meaning that there's
a risk for more mistakes because a clean backup process would require
more steps.

With the current position of the fields in ControlFileData, there are
three free bytes after backupEndRequired, so it is possible to add
that for free.  Now, would you actually need an extra field knowing
that backupStartPoint is around?
--
Michael

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Why is hot_standby_feedback off by default?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Add recovery to pg_control and remove backup_label