Re: Fix permissions check on pg_stat_get_wal_senders

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Fix permissions check on pg_stat_get_wal_senders
Дата
Msg-id CAB7nPqQH19tU2NzWwZTDYrXPYqfM8WkmUsFJD+5ZWT4H6MUfng@mail.gmail.com
обсуждение исходный текст
Ответ на Fix permissions check on pg_stat_get_wal_senders  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Ответы Re: Fix permissions check on pg_stat_get_wal_senders  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Список pgsql-hackers
On Thu, Dec 21, 2017 at 7:30 PM, Feike Steenbergen
<feikesteenbergen@gmail.com> wrote:
> Fix permissions check on pg_stat_get_wal_senders
>
> Commit 25fff40798fc4ac11a241bfd9ab0c45c085e2212 introduced the
> possibility for the pg_read_all_stats to have access to all pg_stat_*
> views.
> In the discussion, the pg_stat_replication and pg_stat_wal_receiver
> views were also considered to be part of that, however
> pg_stat_get_wal_senders was somehow not part of that commit, that
> seems an oversight.
>
> 1: https://www.postgresql.org/message-id/CA%2BOCxoyYxO%2BJmzv2Micj4uAaQdAi6nq0w25BPQgLLxsrvTmREw%40mail.gmail.com\

Yes, that's a bug, albeit a minor one.

-        * Only superusers can see details. Other users only get the pid value
-        * to know whether it is a WAL receiver, but no details.
+        * Only superusers and members of pg_read_all_stats can see details.
+        * Other users only get the pid value to know it's a
walsender, but no details.
You mean a WAL receiver here, not a WAL sender.
-- 
Michael


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Beena Emerson
Дата:
Сообщение: Re: [HACKERS] Runtime Partition Pruning
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Reproducible builds: genbki.pl and Gen_fmgrtab.pl