摘要：
1.查找配置文件#find/-namepg_hba.conf#find/-namepostgresql.conf2.修改2.1修改pg_hba.conf查找IPv4localconnections修改默认的hostallall127.0.0.1/32trust为hostallall192.168.1.1/32trust#IP全匹配或hostallall192.168.1.1/24trust#IP匹
1. 查找配置文件
# find / -name pg_hba.conf
# find / -name postgresql.conf2.修改
2.1 修改pg_hba.conf
查找IPv4 local connections
修改默认的
host all all 127.0.0.1/32 trust为
host all all 192.168.1.1/32trust #IP全匹配
或
host all all 192.168.1.1/24trust #IP匹配前三段
或
host all all 0.0.0.0/0 trust #全部允许2.2 修改postgresql.conf
查找Connection Settings
修改默认的
listen_addresses = 'localhost'为
listen_addresses = '*'重启postgresql服务