1.在所装PostgreSQL机器上的PostgreSQL/8.3/data/pg_hba.conf如下修改:
# IPv4 local connections:host all all 127.0.0.1/32 md5host 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 detailstcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; # 0 selects the system defaulttcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; # 0 selects the system defaulttcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system default
ok!