Thread: 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