Does recovery write to backup_label ?

Поиск
Список
Период
Сортировка
От Chapman Flack
Тема Does recovery write to backup_label ?
Дата
Msg-id a9503f2f-6dec-e0e8-1d7b-f906c3260081@anastigmatix.net
обсуждение исходный текст
Ответы Re: Does recovery write to backup_label ?  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Just saw this in a PG 11.6 cluster starting a recovery:

2020-02-07 10:45:40 EST FATAL:  42501: could not open file
"backup_label": Permission denied
2020-02-07 10:45:40 EST LOCATION:  fsync_fname_ext, fd.c:3531

The label file was written with mode 0400 by a script that got
the contents from pg_stop_backup(boolean,boolean).

But during recovery, it is being poked at by fsync_fname_ext
which wants to open it O_RDWR.

I had assumed the label file would be treated as readonly
during recovery.

If the file needs to have 0600 permissions, should there be
a note in the nonexclusive-mode backup docs to say so?

Regards,
-Chap




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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [PATCH] Erase the distinctClause if the result is unique by definition
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: schema variables