'Connection timed out' when connecting on heroku database using 'pg:psql' command

0

I am trying to connect to my database on heroku, which I would use on my app. I'm using either Command Line or Git Bash on windows.

I have created database on heroku named postgresql-rectangular-87454 and installed Postgres without any errors.

Typing heroku addons I'm making sure, database is set up:

$ heroku addons

Add-on                                            Plan       Price  State
────────────────────────────────────────────────  ─────────  ─────  ───────
heroku-postgresql (postgresql-rectangular-87454)  hobby-dev  free   created
 └─ as DATABASE

but when I try to connect it via heroku pg:psql or also heroku pg:psql postgresql-rectangular-87454 --app salty-shelf-36209, I get this error:

$ heroku pg:psql
--> Connecting to postgresql-rectangular-87454
psql: could not connect to server: Connection timed out (0x0000274C/10060)
        Is the server running on host "ec2-54-225-97-112.compute-1.amazonaws.com" (54.225.97.112) and accepting
        TCP/IP connections on port 5432?

Any advice would be appreciated. Thank you!

node.js
postgresql
heroku
psql
asked on Stack Overflow Oct 2, 2018 by Dromediansk

1 Answer

2

Without knowing more, my first guess would be network rules -- that the connection is being blocked by a local firewall. The pg:psql command simply grabs the DATABASE_URL from your application config and passes the connection string to your local psql command to create the connection. If you're behind a corporate firewall, you may need to speak with your IT department about making an outbound connection.

answered on Stack Overflow Oct 2, 2018 by jmccartie

User contributions licensed under CC BY-SA 3.0