Problem connecting to Heroku database with pgAdmin III client

I am having problems connecting to heroku database using pgAdmin3. I added server add options to pgAdmin3 as described in this question / answer . The error I am getting is FATAL: password authentication failed for user "hliegpkjabvrpe". I can connect to the database using heroku pg: psql. When I look at the heroku -t logs, I see no sign of a failed login.

The message shows that pgAdmin3 reaches the server but is rejected. I have checked and double-checked the password. I am copying it directly from heroku page with connection parameters.

Is there a place where I can get a more detailed description of the reason for the authentication failure? Am I missing something obvious here?

I am running pgAdmin3, version1.18 on windows 8. I have the heroku db name in the support db slot as described in the question / answer above. And I have included ssl. What am I missing?

Any help would be appreciated MOST!

+3


source to share


2 answers


If you haven't, you need to select "require" for SSL on the SSL tab.



0


source


Try the credentials given: heroku pg:credentials DATABASE



0


source







All Articles