koen.vm
koen.vm

Reputation: 9

Heroku postgres connection failed because of password auth

I want to connect to the heroku postgres database I have set up using spring boot java. But before that I wanted to try and connect using pgAdmin 4. When I tried this I got an error saying the authentication for the 'username' had failed. Then I started adding the database to my application.proporties file in spring boot to test it there. I got the samen error message. This is the error message I got in spring boot: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "username". I then even tried it in DBeaver. But still the same error.

heroku postgres credentials

application.properties in spring boot java

I checked multiple times if the password and username are the same. I really don't know what to do now, because I can't find any documantation on the heroku website

Upvotes: 1

Views: 480

Answers (1)

Etnier
Etnier

Reputation: 11

I'm NO EXPERT but I did have the same problem. I think I fixed it on the page with fields for Host, Port, Maintenance database, Username, Password, ... and then by toggling "save password."

Upvotes: 1

Related Questions