Heroku wrong credentials for postgresql database

Question

i’m using heroku for deploy a database (postgres) and connect to it. I used it for 2 weeks but today it start rejecting my credential and i couldn’t login anymore, i checked if the credential are changed but nothing? Can anyone help me? thanks a lot!

Are you using the DATABASE_URL environment variable every time you connect? — Chris
– Chris, Commented May 4, 2022 at 17:27
I used the url they give me in the settings of database and it works for two weeks if i try to connect to database with datagrip it give me an error with credentials too @Chris — Niccoló Balzarotti
– Niccoló Balzarotti, Commented May 4, 2022 at 17:34
I'm not familiar with DataGrip. It looks like a database IDE? What is the specific error that you are receiving? — Chris
– Chris, Commented May 4, 2022 at 18:35

HTML Codes Dude · Accepted Answer · 2022-05-31 19:10:52Z

1

I had this issue, if you look in the Settings -> Config Vars you will see that the DATABASE_URL has changed. So you need to use the new value in Datagrip and things will work again. They change the details periodically but it doesn't seem to update in the database settings page which is very annoying although it only happens on the free tier.

answered May 31, 2022 at 19:10

HTML Codes Dude

611 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

o4zloiroman Over a year ago

To get an updated DATABASE_URL do the heroku config:get DATABASE_URL with the heroku-cli,

Collectives™ on Stack Overflow

Heroku wrong credentials for postgresql database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related