This doesn't seem like fitting here, but.. At Fri, 18 Nov 2022 18:38:56 +0530, Satya Thirumani <satyanarayana.thirum...@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