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 /var/libpgsql/9.4/data
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
got error:
Stopping postgresql-9.4 service: [ OK ]
Starting postgresql-9.4 service: [FAILED]
tail /var/lib/pgsql/9.4/pgstartup.log,got
< 2015-11-22 11:47:42.691 CST >LOG: could not create IPv6 socket: Address family not supported by protocol
< 2015-11-22 11:47:42.718 CST >LOG: redirecting log output to logging collector process
< 2015-11-22 11:47:42.718 CST >HINT: Future log output will appear in directory "pg_log".
Questions are:
1, Is this "could not create IPv6..." just a warning or the actual reason of starting failure?
2, Where is the pg_log directory?
