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

From Alvaro Herrera
Subject Re: Allow replication roles to use file access functions
Date
Msg-id 20150902195201.GW2912@alvherre.pgsql
Whole thread Raw
In response to Allow replication roles to use file access functions  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Allow replication roles to use file access functions  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
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?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pg_upgrade remote copy
Next
From: Jim Nasby
Date:
Subject: Re: Fwd: Core dump with nested CREATE TEMP TABLE