Обсуждение: Allowing non-SUPERUSER to use Server Status to see logfiles

Поиск
Список
Период
Сортировка

Allowing non-SUPERUSER to use Server Status to see logfiles

От
Jeff Janes
Дата:
Is there a way to designate a specific non-SUPERUSER role to be able to see the pg_log logfiles via pgAdmin?

I could write wrapper functions with SECURITY DEFINER with the correct rights to observe the pg_log directory, but without the ability to get pgAdmin to invoke the wrapper functions in place of the usual functions, it won't do me much good.


Thanks,

Jeff