centos7 使用postgres

1:

http://www.cnblogs.com/think8848/p/5877076.html

 2:http://blog.csdn.net/xuaa/article/details/52262169

开启防火墙5432端口　　

//tuichu
postgres=# q
bash-4.2$ sudo firewall-cmd --zone=public --add-port=5432/tcp --permanent
[sudo] password for postgres: 
Sorry, try again.
[sudo] password for postgres: 
Sorry, try again.
[sudo] password for postgres: 
Sorry, try again.
sudo: 3 incorrect password attempts
bash-4.2$ su
Password: 
[root@localhost ~]# sudo firewall-cmd --zone=public --add-port=5432/tcp --permanent
success
[root@localhost ~]# sudo firewall-cmd --reload
success
[root@localhost ~]#