在这里插入图片描述

解决办法

修改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

重启

数据库查询中执行：SELECT pg_reload_conf()，
或者重启pgsql服务

在这里插入图片描述
在这里插入图片描述

版权声明：本文为qq_37746855原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
原文链接：https://blog.csdn.net/qq_37746855/article/details/119537375