1、编辑/var/lib/pgsql/data/pg_hba.conf
,增加语句 host all all 192.168.105.225/36 trust 让数据库接受网络
192.168.105.225/36
2、编辑/var/lib/pgsql/data/postgresql.conf
,设置选项 listen_addresses='*'
3、重启数据库 /etc/init.d/postgresql restart
*4、允许网口通信:
iptables -A INPUT -p tcp -s 0/0 --sport 1024:65535 -d 10.10.29.50 --dport 5432 -m state --state NEW,ESTABLISHED -j ACCEPT
iptables -A OUTPUT -p tcp -s 10.10.29.50 --sport 5432 -d 0/0 --dport 1024:65535 -m state --state ESTABLISHED -j ACCEPT
参考原文:http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html