I was unable to access a remote AWS postgres database via things
psql -h *EC2ExternalIP* -U *me*. I would get:
psql -h *EC2ExternalIP* -U *me* psql: could not connect to server: Operation timed out Is the server running on host *EC2ExternalIP* and accepting TCP/IP connections on port 5432?
same thing trying a simple telnet connection to this port:
curl telnet://*EC2ExternalIP*:5434 curl: (7) Failed to connect to *EC2ExternalIP* port 5434: Operation timed out
and even though i could access other services (eg, apache) on this same EC2ExternalIP.
So I poked around at threads like these:
and they helped me to ensure I'd made appropriate modifications to
pg_hba.conf; the right settings for you will
depend on your instance's security concerns. But it is still not
What should I do to make this DB accessible?