Re: BUG #16279: Permissions doc incorrect for pg_buffercache

Поиск
Список
Период
Сортировка
Искать
От
Philip Semanchuk
Тема
Re: BUG #16279: Permissions doc incorrect for pg_buffercache
Дата
Msg-id
D85A0DF0-A631-43B6-B92D-7B22433B9FA7@americanefficient.com
Ответ на
Список
Дерево обсуждения
BUG #16279: Permissions doc incorrect for pg_buffercache PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Sergei Kornilov <sk@zsrv.org>
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Philip Semanchuk <philip@americanefficient.com>
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Philip Semanchuk <philip@americanefficient.com>
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Tom Lane <tgl@sss.pgh.pa.us>


> On Feb 26, 2020, at 12:11 PM, Sergei Kornilov  wrote:
> 
> Hello
> 
> You are right, in contrib/pg_buffercache/pg_buffercache--1.2--1.3.sql we have
> 
> GRANT EXECUTE ON FUNCTION pg_buffercache_pages() TO pg_monitor;
> GRANT SELECT ON pg_buffercache TO pg_monitor;
> 
> Not pg_read_all_stats. I'm not sure: we need change the extension or fix the documentation? I think pg_read_all_stats would be more appropriate, but we need bump the extension version.


Thanks for exploring and confirming! I agree that pg_read_all_stats would be more appropriate. 

Cheers
Philip

В списке pgsql-bugs по дате отправления
От: Alvaro Herrera
Дата:
От: Tom Lane
Дата:
FAQ