Heroku Postgresql local connection

Question

Everything worked great until today, while I did not change anything in the code. I can't connect to the database not from the application, not from the IDE, did something go wrong on the heroku side? I have not seen news with global updates over the past couple of days on the heroku website. Can anyone advise how to solve the current problem? I use the free version of dyno and postgresql, I definitely still have a lot of free space (less than 1 thousand fields). It looks like blocking access to the database locally, not from the service side.

Are you getting your connection information from the app's DATABASE_URL environment variable? That information can change at any time. — Chris
– Chris, Commented Jun 8, 2022 at 19:30
@Chris I checked It, It still the same. Seems to me that Heroku or Amazon blocked access from remote IDE like dbeaver. Don't you meet the same issue? Everything work from dyno but not from my local computer anymore. — Wotori Movako
– Wotori Movako, Commented Jun 8, 2022 at 21:33

jory · Accepted Answer · 2022-06-08 19:02:15Z

1

What I would try in your situation:

Go to https://data.heroku.com/, select your Datastore and check everything there: Health, number of connections, number of rows, data size.
If everything is fine: Go to settings -> database credentials and try setting up a connection from any desktop tool such as Navicat or Pgadmin. What error message do you get?
Set-up another database on Heroku and try the same. If the second DB works, there is an issue with the first one. If it does not, it's rather about your setup/settings.

Hope that helps

answered Jun 8, 2022 at 19:02

jory

8121 gold badge6 silver badges4 bronze badges

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

1 Comment

Wotori Movako Over a year ago

Thanks for share the link! It works now, I didn't change anything. Perhaps it was downtime? For hobby tier it is "< 4 hr downtime per mo." but for me it was more, around 8 hours of downtime. Strange... At least now we know that it was not blocked from outside by Heroku or Amazon

Collectives™ on Stack Overflow

Heroku Postgresql local connection

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