I want certain users to be able to examine running queries using
pg_stat_get_backend_activity. Unfortunately, this will only show other
users' activity if you have superuser privilege.
I do not want to give monitoring users superuser privilege, but I do
need to allow them to perform monitoring tasks.
I've tried tricks with security definer functions but this does not help
as pg_stat_get_backend_activity explicitly checks for the caller being a
superuser.
Aside from implementing my own version of pg_stat_get_backend_activity
in C, does anyone have any suggestions?
Should there be a standard privilege that allows this (please say yes)?
__
Marc