When trying to run
heroku pg commands I am seeing the following error:
--> Connecting to postgresql-example-12345 psql: could not connect to server: Connection timed out (0x0000000C/10000) Is the server running on host "ec2-123-45-678-910.compute-1.amazonaws.com" (188.8.131.52) and accepting TCP/IP connections on port 5432?
This error is because the
heroku command line tools are unable to use the required ports. This is often because a corporate firewall is blocking the following ports:
5432- this is required for communicating with Postgres database
5000- this is required for communication with one-off dynos (e.g.
heroku run bash)