From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | mdevan(dot)r(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: [BUGS] BUG #14860: pg_read_all_stats and pg_stat_replication |
Date: | 2018-01-10 20:53:48 |
Message-ID: | 20180110205348.GF29178@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Oct 18, 2017 at 12:40:22PM +0000, mdevan(dot)r(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14860
> Logged by: Mahadevan R
> Email address: mdevan(dot)r(at)gmail(dot)com
> PostgreSQL version: 10.0
> Operating system: any
> Description:
>
> User with pg_read_all_stats privilege is not able to read
> some columns (listed below) from the pg_stat_replication
> view. This is because these columns come from the function
> pg_stat_get_wal_senders(), and this function returns non-null
> values only for superuser.
>
> To reproduce, set up streaming replication, and a user with
> pg_read_all_stats privilege and "select * from
> pg_stat_replication". The following columns will be null:
>
> state
> sent_lsn
> write_lsn
> flush_lsn
> replay_lsn
> sync_priority
> sync_state
This bug was also reported here:
and fixed here:
commit 6668a54eb8ef639a3182ae9e37e4e67982c44292
Author: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Date: Sat Jan 6 11:48:21 2018 +0000
Default monitoring roles - errata
25fff40798fc4ac11a241bfd9ab0c45c085e2212 introduced
default monitoring roles. Apply these corrections:
* Allow access to pg_stat_get_wal_senders()
by role pg_read_all_stats
* Correct comment in pg_stat_get_wal_receiver()
to show it is no longer superuser-only.
Author: Feike Steenbergen
Reviewed-by: Michael Paquier
Apply to HEAD, then later backpatch to 10
The fix will appear in the next PG 10 minor release.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-01-10 23:14:42 | Re: BUG #14941: Vacuum crashes |
Previous Message | Bruce Momjian | 2018-01-10 20:10:54 | Re: [BUGS] BUG #14857: Typo in pg_dump italian translation |