Thread: Allowing non-SUPERUSER to use Server Status to see logfiles

Allowing non-SUPERUSER to use Server Status to see logfiles

From

Jeff Janes

Date:

06 August 2015, 22:37:40

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