[BUGS] pg_read_all_stats and pg_stat_replication in postgres 10.

Поиск
Список
Период
Сортировка
От Mahadevan R
Тема [BUGS] pg_read_all_stats and pg_stat_replication in postgres 10.
Дата
Msg-id CAAP+Li9zo1es45ci6TfhWJaAhj_Fa7_xyc9KoEMAYWQAkErGkg@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
Hello,

In Postgres 10 (release version installed from apt repo on Debian 9), the following columns of the pg_stat_replication view are returned as null for a user who has been granted pg_read_all_stats:

state
sent_lsn
write_lsn
flush_lsn
replay_lsn
sync_priority
sync_state

Other columns (like client_addr, backend_start) have valid values. Other views (like pg_stat_activity) also have valid values. Granting pg_monitor does not help. Only superuser is able to retrieve these values (like it was in 9.6).

Is this a bug?

Thanks,
-Mahadevan

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [BUGS] pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI
Следующее
От: mdevan.r@gmail.com
Дата:
Сообщение: [BUGS] BUG #14860: pg_read_all_stats and pg_stat_replication