Edit Question - KnowledgeHub

Title Body

I have a micro free tier RHEL 6 instance running and have postgresql 9.2 installed using the yum instructions here: http://yum.pgrpms.org/howtoyum.php And I am able connect to the PG server locally using this on server: 03:46:20 root@xxx[~]$ psql -hlocalhost -p5432 -Upostgres However i've never successfully connected to it outside of box. The error message looks like: 12:11:56 saladinxu@GoodOldMBP[~]$ psql -h ec2-xxx.ap-southeast-1.compute.amazonaws.com -p5432 -Upostgres psql: could not connect to server: Connection refused Is the server running on host "ec2-54-251-188-3.ap-southeast-1.compute.amazonaws.com" (54.251.188.3) and accepting TCP/IP connections on port 5432? I've tried a bunch of different ways. Here's how my configure files look now: /var/lib/pgsql/9.2/data/postgresql.conf: ... # - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost'; use '*' for all port = 5432 # (change requires restart) max_connections = 100 # (change requires restart) ... /var/lib/pgsql/9.2/data/pg_hba.conf: # TYPE DATABASE USER ADDRESS METHOD host all pgadmin 0.0.0.0/24 trust host all all [my ip]/24 md5 # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 ident # IPv6 local connections: host all all ::1/128 ident I've tried to make the above address to 0.0.0.0/0 but id didn't work. And every time i made a change i r

Tags (comma-separated) Cancel