允许客户端远程访问
1.在postgres主目录下的data中比如:C:\Program Files\PostgreSQL\9.3\data\postgresql
(1)监听任何地址访问,修改连接权限
#listen_addresses = ‘localhost’改为 listen_addresses = ‘*’
(2)启用密码验证
#password_encryption = on改为password_encryption = on
2.可访问的用户ip段:打开pg_hba.conf文档,存放路径比如:C:\Program Files\PostgreSQL\9.3\data\pg_hba.conf
并在文档末 尾加上以下内容
#
to allow your client visiting postgresql server
host all all 0.0.0.0 0.0.0.0 md5
3.重启PostgreSQL数据库命令:
root@server2-virtual-machine:~# /etc/init.d/postgresql restart