Re: Allow replication roles to use file access functions - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Allow replication roles to use file access functions
Date
Msg-id CAB7nPqQHkErwdGE6dsksrq3zokwjUuKwF+eYSim4=f+61m1sFg@mail.gmail.com
Whole thread Raw
In response to Re: Allow replication roles to use file access functions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Allow replication roles to use file access functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Allow replication roles to use file access functions  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Thu, Sep 3, 2015 at 4:52 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Michael Paquier wrote:
>> Hi all,
>>
>> As of now, file access functions in genfile.c can only be used by
>> superusers. This proposal is to relax those functions so as
>> replication users can use them as well. Here are the functions aimed
>> by this patch:
>> - pg_stat_file
>> - pg_read_binary_file
>> - pg_read_file
>> - pg_ls_dir
>> The main argument for this change is that pg_rewind makes use of those
>> functions, forcing users to use a superuser role when rewinding a
>> node.
>
> Can this piggyback on Stephen Frost's proposed patch for reserved roles et al?

(Adding Stephen in the loop)
I thought that this was rather independent on Stephen's default role
patch because this is not based on a new role permission type.
Stephen, do you think so, or should we merge the effort with your
things?
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Allow replication roles to use file access functions
Next
From: Peter Geoghegan
Date:
Subject: Re: Memory prefetching while sequentially fetching from SortTuple array, tuplestore