My postgresql 9.4 is installed in centos 6.7,and I have followed this:
http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/
1,cd /usr/pgsql-9.4/share/
2,cp postgresql.conf.sample postgresql.conf
3,sudo vi postgresql.conf and add two lines,and save it:
listen_addresses = "*"
tcpip_socket = true
4,cp pg_hba.conf.sample pg_hba.conf
5,sudo vi pg_hba.conf then commented(maybe this is uneccessary)
#host all all 127.0.0.1/32 @authmethodhost@
#host all all ::1/128 @authmethodhost@
6,add two lines:(I have tried to change md5 to trust,neither works)
host all all 0.0.0.0/0 md5
host all all ::0/0 md5
7,then save:pg_hba.conf
8,then restart postgresql sever by
sudo service postgresql-9.4 restart
9.close iptables
sudo service iptables stop
10,and ask another guy in different city to try to connect by
psql -U postgres -h 135.211.67.23
He got error
psql: could not connect to server: Connection refused
Is the server running on host "135.211.67.23" and accepting
TCP/IP connections on port 5432?
and I tried to run same some command in the host(centos),got same error.
12.Running: "netstat -lputn" in the host got
.....
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN -
....
So,How to solve this problem?
