Not the answer you need?
Register and ask your own question!

Postgres and seeing other schemas/roles/databases

kwolfe19kwolfe19 Current User Role Novice

So I've got PMM set up and I can see certain things, but I can't (in QAN) see everything. I can see the pmm_user and postgres database for example, but I cannot see the database where all of my schemas (and tables are). I also can not see any of the other users/roles. I am guessing this is a missing role/permission thing from pmm_user. I can see queries that are being run by pmm_user through QAN. Any idea on what I need to do to be able to see the details about the other databases and schemas?

I am running Postgres 9.6 hosted in GCP, and it is DaaS.

Thank you!


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.