PostgreSQL安装后Navicat客户端连接报错如下:
postgresql.conf
#listen_addresses = '*'
listen_addresses = '*'
pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 trust
1.查看防火墙状态
systemctl status firewalld
firewall-cmd --state #查看默认防火墙状态(关闭后显示notrunning,开启后显示running)
2.查看防火墙是否开机启动
systemctl is-enabled firewalld
3.关闭防火墙
systemctl stop firewalld
systemctl stop firewalld.service
systemctl status firewalld
4.禁用防火墙(系统启动时不启动防火墙服务)
systemctl disable firewalld
systemctl disable firewalld.service
systemctl is-enabled firewalld
上面文件已修改,防火墙已关闭,还是连不上。。。
后来发现申请的服务器是给的堡垒机的(测试或线上环境用的),是不允许连接的。。。
然后又重申的开发环境的服务器。。。