首页 > 代码库 > postgreSQL远程连接出现：Error connecting to server :致命错误 SSL关闭的pg_hba.conf记录
postgreSQL远程连接出现：Error connecting to server :致命错误 SSL关闭的pg_hba.conf记录
异常截图：
解决方案：
[root@www ~]# vi /var/lib/pgsql/data/pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD# "local" is for Unix domain socket connections onlylocal all all ident# IPv4 local connections:host all all 127.0.0.1/32 identhost all all 10.10.46.1/24 md5 # 新添加# IPv6 local connections:host all all ::1/128 ident
备注：如出现监听异常，请修改
[root@www ~]# vi /var/lib/pgsql/data/postgresql.conf listen_addresses = ‘*‘ # what IP address(es) to listen on; 移除注释
# comma-separated list of addresses;
# defaults to ‘localhost‘, ‘*‘ = all
# (change requires restart)
port = 5432 # (change requires restart) 移除注释
#ssl_renegotiation_limit = 512MB # amount of data between renegotiations
password_encryption = on # 移除注释
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。