DBvisual 10 连接 PostgreSQL 时出现以下情况:
FATA:no pg_hba.conf entry for host "192.168.233.1",user "postgres",database "postgres",SSL off
解决办法:
编辑pg_hba.conf配置文件:
将11替换成你所安装的版本:
vim /var/lib/pgsql/11/data/pg_hba.conf
在里面添加:
host all all 0.0.0.0/0 md5
重启服务器:
systemctl restart postgresql-11
参考链接:https://blog.csdn.net/qq_32596527/article/details/83626617