远程连接postgresSQL8.3服务器

最新推荐文章于 2023-08-22 15:08:39 发布

onlyzhaozhen

最新推荐文章于 2023-08-22 15:08:39 发布

阅读量98

点赞数

分类专栏：大数据存储文章标签： PostgreSQL

大数据存储专栏收录该内容

73 篇文章

订阅专栏

本文介绍了如何通过修改PostgreSQL配置文件pg_hba.conf和postgresql.conf来实现特定IP地址的远程访问，并设置了信任认证方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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！