Re: pg_stat_replication security - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: pg_stat_replication security
Date
Msg-id AANLkTimohcid7xo1Jv08d37aT2zYn2GrN34SD5SfYS8y@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_replication security  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_stat_replication security  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Sun, Jan 16, 2011 at 21:51, Josh Berkus <josh@agliodbs.com> wrote:
>
>> I suggest pg_stat_replication do just like pg_stat_activity, which is
>> return NULL in most fields if the user isn't
>> (superuser||same_user_as_that_session).
>
> What session would that be, exactly?

The user doing the query to pg_stat_replication being the same as the
user running the replication.


> I suggest instead either "superuser" or "replication" permissions.

That's another idea.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: replication and pg_hba.conf
Next
From: Josh Berkus
Date:
Subject: Re: pg_stat_replication security