Home > Net >  Heroku Postgresql local connection
Heroku Postgresql local connection

Time:06-09

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.

CodePudding user response:

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

  • Related