Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Migration of data from PostgreSQL 9.1.13 to PostgreSQL 9.3 Question Question
How to give root files permision to postgres Question Question

Question

query pg_stat_statements privileges

Posted August 26, 2020 894 views
PostgreSQL

Hi,

Even when I connect with doadmin I get query column showing “<insufficient privilege>”, I need to do some queries of my own on that view, how can I do that?

Add a comment
allochi
By:
allochi

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Migration of data from PostgreSQL 9.1.13 to PostgreSQL 9.3 Question Question
How to give root files permision to postgres Question Question
Add a comment
2 comments
  • smorales September 14, 2020
    Reply Report

    Did you resolve this problem? I’m running into exactly the same situation.

  • milkfarm November 6, 2021
    Reply Report

    Same “<insufficient privilege>” situation for me. Any hope of getting access? From SO, and out of desperation, I tried:

    > GRANT pg_read_all_stats TO user_name;
ERROR:  must have admin option on role "pg_read_all_stats"

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
allochi September 15, 2020

@smorales unfortunately no, I did not, and DigitalOcean is not interested to answer this question, so indirectly they are suggesting a radical solution.

Reply Report

Related

Looking for something else?

Ask a new question Search for more help