navicat连接pgsql报错：authentication method 10 not supported

navicat连接pgsql报错：authentication method 10 not supported

解决方案：找到pgsql的安装目录下的pg_hba.conf文件

用文本编辑器打开后做如下修改，然后再数据库查询中执行：SELECT pg_reload_conf()，即可，或者重启pgsql服务

添加代码如下：

# "local" is for Unix domain socket connections only
local   all             all                           trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust