heroku postgresql could not connect to server: Connection timed out

1

I'm trying to connect to postgres database in heroku using heroku pg:psql postgresql-rigid-33416 --app murmuring-ocean-62645, however I got this message

--> Connecting to postgresql-rigid-33416
psql: could not connect to server: Connection timed out (0x0000274C/10060)
        Is the server running on host "ec2-50-17-225-140.compute-1.amazonaws.com" (50.17.225.140) and accepting
        TCP/IP connections on port 5432?

I have tried to turn off my firewall but the problem persists. Any idea how to solve this?

EDIT:

heroku version
heroku/7.16.0 win32-x64 node-v10.10.0

heroku pg:info
=== DATABASE_URL
Plan:                  Hobby-dev
Status:                Available
Connections:           0/20
PG Version:            10.5
Created:               2018-10-09 14:03 UTC
Data Size:             7.6 MB
Tables:                0
Rows:                  0/10000 (In compliance)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-rigid-33416
postgresql
heroku
asked on Stack Overflow Oct 30, 2018 by Bla... • edited Nov 3, 2018 by Bla...

1 Answer

1

In case someone else has this issue. I had same problem. I had to lower my network security by changing my Firewall Level on my local compter to 'Low' and it works.

answered on Stack Overflow Apr 14, 2019 by olucube.com • edited Apr 15, 2019 by olucube.com

User contributions licensed under CC BY-SA 3.0