Re: [HACKERS] PATCH: Configurable file mode mask - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] PATCH: Configurable file mode mask
Date
Msg-id 7669.1488803924@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] PATCH: Configurable file mode mask  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [HACKERS] PATCH: Configurable file mode mask  (Robert Haas <robertmhaas@gmail.com>)
Re: [HACKERS] PATCH: Configurable file mode mask  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On 1 March 2017 at 01:58, David Steele <david@pgmasters.net> wrote:
>> PostgreSQL currently requires the file mode mask (umask) to be 0077.
>> However, this precludes the possibility of a user in the postgres group
>> performing a backup (or whatever).  Now that
>> pg_start_backup()/pg_stop_backup() privileges can be delegated to an
>> unprivileged user, it makes sense to also allow a (relatively)
>> unprivileged user to perform the backup at the file system level as well.

> +1

I'd ask what is the point, considering that we don't view "cp -a" as a
supported backup technique in the first place.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Allow vacuums to report oldestxmin
Next
From: Christoph Berg
Date:
Subject: Re: [HACKERS] One-shot expanded output in psql using \gx