Skip to content
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 our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error on starting service #4

Closed
kmroz9 opened this issue Jul 22, 2016 · 2 comments
Closed

error on starting service #4

kmroz9 opened this issue Jul 22, 2016 · 2 comments
Labels

Comments

@kmroz9
Copy link

kmroz9 commented Jul 22, 2016

Hello,
I am getting this error while starting the service.
"ERROR - 2016-07-22 21:42:55,764 Got an error during query execution
ERROR - 2016-07-22 21:42:55,764 permission denied for schema pganalyze"

Any idea what it is?
I re-ran through all the instructions again. https://pganalyze.com/docs/install/amazon_rds/02_create_monitoring_user

@lfittl
Copy link
Member

lfittl commented Jul 23, 2016

@kmroz9 That seems odd, can you verify that you ran these two commands:

REVOKE ALL ON SCHEMA public FROM pganalyze;
GRANT USAGE ON SCHEMA pganalyze TO pganalyze;

In addition, can you check if you did actually specify the pganalyze user as the username you are connecting with?

@lfittl
Copy link
Member

lfittl commented Aug 1, 2016

Closing this question due to inactivity - please feel free to re-open or reach out to us at team@pganalyze.com if this is still a problem.

@lfittl lfittl closed this as completed Aug 1, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants