Heroku Postgres database : connecting from outside Heroku


I have added a configured postgres database add-on to a heroku app. When I try to connect to the database outside the heroku (from my local machine) it always gives an error

SSL SYSCALL error: Connection reset by peer (0x00002746/10054)

I have tried connection from Heroku CLI as well as PGAdmin. I have tried configuring SSL mode to Require.

psql -h ec2-79-125-6-82.eu-west-1.compute.amazonaws.com -U d168639egmjee csjpgbglovnmah

Any idea how can I connect to the postgres DB added in heroku app?

Any help will be appreciated.

asked on Stack Overflow Oct 25, 2017 by Varada Kamat • edited Oct 25, 2017 by Varada Kamat

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0