I just created a brand new EC2 instance with a default security group allowing All Traffic from Anywhere.
My listen_address is set to
I can SSH to it but I can't connect to the pgsql instance running inside it, UNLESS I change the port to something other than
This Setup Fails:
psql -h <public-ip> -p 5432
psql: could not connect to server: Operation timed out`
psql -h <public-ip> -p 6000
I tried this twice in two different AWS accounts, same behavior.
no iptables rules are present either, it's a brand new EC2 instance:
ubuntu@<public-ip>:~$ sudo iptables -L -n Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination
This doesn't make sense to me at all.
This is the version of Ubuntu I'm running:
ubuntu@<public-ip>:~$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.2 LTS Release: 14.04 Codename: trusty
psql (PostgreSQL) 9.3.6
The weirdest thing it was working yesterday, no changes has been made except that I upgraded to
Yosemite 10.10.3 (14D136.
I checked with another EC2 instance in the cloud as client, it connect, it seems to be my OSX, again, since I updated to
psql, none of my client apps are able to connect.
"host=<public-ip> port=5432 sslmode=disable" didn't worked neither.