PostgreSQL使用Navicat连接pgsql时出现authentication method 10 not supported的解决办法

最新推荐文章于 2023-11-24 11:36:34 发布

eeenkidu

最新推荐文章于 2023-11-24 11:36:34 发布

阅读量2.4w

点赞数 8

分类专栏： postgresql 文章标签： postgresql navicat

本文链接：https://blog.csdn.net/qq_37746855/article/details/119537375

版权

postgresql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

在这里插入图片描述

解决办法

修改pgsql的安装目录下的pg_hba.conf文件
在这里插入图片描述

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
# local   all             all                                     scram-sha-256
# IPv4 local connections:
# host    all             all             127.0.0.1/32            scram-sha-256
# IPv6 local connections:
# host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
# local   replication     all                                     scram-sha-256
# host    replication     all             127.0.0.1/32            scram-sha-256
# host    replication     all             ::1/128                 scram-sha-256

# "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