- Notifications
You must be signed in to change notification settings - Fork805
Fix 'pq: permission denied for function pg_ls_waldir' on PG v16.6#1101
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
base:master
Are you sure you want to change the base?
Fix 'pq: permission denied for function pg_ls_waldir' on PG v16.6#1101
Uh oh!
There was an error while loading.Please reload this page.
Conversation
… v16.6.Signed-off-by: kakuiho <61496907+kakuiho@users.noreply.github.com>
kakuiho commentedFeb 5, 2025
@khiemdoan Could you please merge this PR? |
khiemdoan commentedFeb 5, 2025
Hi@kakuiho, |
| SELECT * FROM get_pg_stat_statements(); | ||
| GRANT SELECT ON postgres_exporter.pg_stat_statements TO postgres_exporter; | ||
| GRANT ALL ON FUNCTION pg_catalog.pg_ls_waldir() TO postgres_exporter; |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
I always hesitate to recommend someone give ALL permissions. I think this only needsEXECUTE. Can you confirm and update?
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
I ran on this comment by chance and did it on my side as I had the error, and it did clear the error from the console when granting only EXECUTE. So I guess it does work 👍
see also#1100