Connect Heroku postgres from localclient

Question

I'm trying to connet with

psql -h ec2-23-23-227-54.compute-1.amazonaws.com -U igcmskkpsx igcmskkpsx

but it answer:

psql: no se pudo conectar con el servidor: Connection timed out (0x0000274C/10060)
        ¿Está el servidor en ejecución en el servidor «ec2-23-23-227-54.compute-1.amazonaws.com» y aceptando
        conexiones TCP/IP en el puerto 5432?

Please any suggestion?

Javier Gutierrez · Accepted Answer · 2012-06-04 02:45:27Z

2

Heroku dosen't allow access from an external client while the account is free; I had to use the cleanMysql plugin to access from my local navicat

answered Jun 4, 2012 at 2:45

Javier Gutierrez

5596 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cheeso Over a year ago

Any chance you can cite the page on heroku.com that states this limitation?

CraigKerstiens · Accepted Answer · 2012-05-19 15:43:57Z

0

You may need to specify the port with -P porthere when connecting if its not runnin gon the default port.

answered May 19, 2012 at 15:43

CraigKerstiens

5,9891 gold badge27 silver badges29 bronze badges

1 Comment

CraigKerstiens Over a year ago

This can depend on the database, it would be specified within the connection string to the database. Additionally you should be able to run: heroku pg:psql or heroku pg:psql COLOR (where color is the db color within the config variable)

Collectives™ on Stack Overflow

Connect Heroku postgres from localclient

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related