# IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.1.60/32 trust
其中
192.168.1.60是允许访问的ip地址,trust表示完全信任。
2.Postgresql/8.3/data/postgresql.conf
找出:
# - TCP Keepalives - # see "man 7 tcp" for details # tcp_keepalives_idle = 0 # TCP_KEEPIDLE,in seconds; # 0 selects the system default # tcp_keepalives_interval = 0 # TCP_KEEPINTVL,in seconds; # 0 selects the system default # tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system default
做出如下修改:
# - TCP Keepalives - # see "man 7 tcp" for details tcp_keepalives_idle = 0 # TCP_KEEPIDLE,in seconds; # 0 selects the system default tcp_keepalives_interval = 0 # TCP_KEEPINTVL,in seconds; # 0 selects the system default tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system defaultok!