Re: pg_basebackup ignores the existing data directory permissions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_basebackup ignores the existing data directory permissions
Date
Msg-id CA+TgmoZw78qVNaGF-CGdQ4=g48G_LtxNWqQK5MNa_J51Z2W9Qw@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup ignores the existing data directory permissions  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: pg_basebackup ignores the existing data directory permissions
Re: pg_basebackup ignores the existing data directory permissions
List pgsql-hackers
On Mon, Mar 18, 2019 at 11:36 AM Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> On 2019-03-18 14:47, Robert Haas wrote:
> >> Based on the feedback gathered, having a separate option to enforce
> >> the default and not touching the behavior implemented until now,
> >> sounds fine to me.
> > That's not what I'm proposing.  I think the behavior implemented until
> > now is not best, because the files within the directory should inherit
> > the directory's permissions, not the remote side's permissions.
>
> I'm strongly in favor of keeping initdb and pg_basebackup options
> similar and consistent.  They are both ways to initialize data directories.
>
> You'll note that initdb does not behave the way you describe.  It's not
> unreasonable behavior, but it's not the way it currently works.

So you want to default to no group access regardless of the directory
permissions, with an option to enable group access that must be
explicitly specified?  That seems like a reasonable option to me; note
that initdb does seem to chdir() an existing directory.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_basebackup ignores the existing data directory permissions
Next
From: Robert Haas
Date:
Subject: Re: Add exclusive backup deprecation notes to documentation