pgsql: Only show pg_stat_replication details to superusers

Started by Magnus Haganderalmost 15 years ago3 messages
#1Magnus Hagander
magnus@hagander.net

Only show pg_stat_replication details to superusers

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f88a638199d8505e7a01548cb647f908ae1e469f

Modified Files
--------------
doc/src/sgml/monitoring.sgml | 4 +++-
src/backend/replication/walsender.c | 16 ++++++++++++++--
2 files changed, 17 insertions(+), 3 deletions(-)

#2Simon Riggs
simon@2ndQuadrant.com
In reply to: Magnus Hagander (#1)
Re: [COMMITTERS] pgsql: Only show pg_stat_replication details to superusers

On Sun, 2011-01-23 at 16:28 +0000, Magnus Hagander wrote:

Only show pg_stat_replication details to superusers

What happens to those with REPLICATION privilege? Denied access?

--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services

#3Magnus Hagander
magnus@hagander.net
In reply to: Simon Riggs (#2)
Re: [COMMITTERS] pgsql: Only show pg_stat_replication details to superusers

On Sun, Jan 23, 2011 at 19:27, Simon Riggs <simon@2ndquadrant.com> wrote:

On Sun, 2011-01-23 at 16:28 +0000, Magnus Hagander wrote:

Only show pg_stat_replication details to superusers

What happens to those with REPLICATION privilege? Denied access?

Correct, same as those without it - only superuser is enough.

For rationale, see the original thread discussing the patch :)

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