Postgres远程连接

Question

我很难让postgres在局域网上允许远程访问。这两个文件如下..。

#postrges.conf

# - Connection Settings - .200 is where the server's IP
listen_addresses = '192.168.0.200,localhost'
port = 5432
...

#pg_hba.conf
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# allow LAN connections only...
host    all             all             192.168.0.0/255         md5

这里出什么问题了？postgres服务器甚至不会重新启动..。

Answer 1

 # allow LAN connections only...
 host    all             all             192.168.0.0/255         md5

尝试将其转换为CIDR符号

 # allow LAN connections only...
 host    all             all             192.168.0.0/32         md5

试着改变

listen_addresses = '192.168.0.200,localhost'

转到

listen_addresses = '*'

关于未重新启动:检查postgres日志文件或liux: /var/log/syslog

如果postgres服务器正在重新启动，请使用

  netstat -tapn