远程连接postgresSQL8.3服务器

发布时间：2020-12-13 17:59:00 所属栏目：百科来源：网络整理

导读：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/post

1.在所装PostgreSQL机器上的PostgreSQL/8.3/data/pg_hba.conf如下修改：

# 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 default

ok！

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!