Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stat_replication security - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: pg_stat_replication security
Date
Msg-id 4D335A6C.2020507@agliodbs.com
Whole thread Raw
In response to pg_stat_replication security  (Magnus Hagander <magnus@hagander.net>)
Responses Re: pg_stat_replication security
List pgsql-hackers
Tree view 
> 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?

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

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: We need to log aborted autovacuums
Next
From: Dimitri Fontaine
Date:
Subject: Re: walreceiver fallback_application_name