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
signature.asc
Description: This is a digitally signed message part
