Unable to reset stats using pg_stat_reset_replication_slot

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