Re: pg_rewind fails if there is a read only file.

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_rewind fails if there is a read only file.
Дата
Msg-id YK2O0h83FFBUnF+s@paquier.xyz
обсуждение исходный текст
Ответ на Re: pg_rewind fails if there is a read only file.  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pg_rewind fails if there is a read only file.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
On Tue, May 25, 2021 at 03:17:37PM -0400, Andrew Dunstan wrote:
> If we do decide to do something the question arises what should it do?
> If we're to allow for it I'm wondering if the best thing would be simply
> to ignore such a file.

Enforcing assumptions that any file could be ready-only is a very bad
idea, as that could lead to weird behaviors if a FS is turned as
becoming read-only suddenly while doing a rewind.  Another idea that
has popped out across the years was to add an option to pg_rewind so
as users could filter files manually.  That could be easily dangerous
though in the wrong hands, as one could think that it is a good idea
to skip a control file, for example.

The thing is that here we actually know the set of files we'd like to
ignore most of the time, and we still want to have some automated
control what gets filtered.  So here is a new idea: we build a list of
files based on a set of GUC parameters using postgres -C on the target
data folder, and assume that these are safe enough to be skipped all
the time, if these are in the data folder.
--
Michael

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: storing an explicit nonce
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: storing an explicit nonce