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