This doesn't seem like fitting here, but..
At Fri, 18 Nov 2022 18:38:56 +0530, Satya Thirumani <satyanarayana.thirumani@gmail.com> wrote in
> I'm unable to reset stats. Please help me to fix this?
>
> testdb => select * from pg_stat_reset_replication_slot(NULL);
> ERROR: permission denied for function pg_stat_reset_replication_slot
Yeah, the user doesn't seem to be allowed to do that. Only superusers
can do that defaultly.
https://www.postgresql.org/docs/devel/monitoring-stats.html
> This function is restricted to superusers by default, but other
> users can be granted EXECUTE to run the function.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center