On Sun, Jan 16, 2011 at 21:51, Josh Berkus <josh(at)agliodbs(dot)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/