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

From: Paul Guo <paulguo(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: pg_rewind fails if there is a read only file.
Date: 2021-05-25 08:57:02
Message-ID: CABQrizc4jQmoS-rDE4XRSEC+kPP00YG3wPU7BjRhxd5k1MUrjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> You seem to have missed my point completely. The answer to this problem
> IMNSHO is "Don't put a read-only file in the data directory".

Oh sorry. Well, if we really do not want this we may want to document this
and keep educating users, but meanwhile probably the product should be
more user friendly for the case, especially considering
that we know the fix would be trivial and I suspect it is inevitable that some
extensions put some read only files (e.g. credentials files) in pgdata.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2021-05-25 09:04:23 Re: Assertion failure while streaming toasted data
Previous Message Paul Guo 2021-05-25 08:39:12 sync request forward function ForwardSyncRequest() might hang for some time in a corner case?