首页 > 解决方案 > PostgreSQL 13 FATAL:用户“postgres”的密码验证失败

问题描述

我在安装过程中输入了正确的密码,出现如下所示的身份验证错误。

阅读类似的问题和答案,但找不到版本 13 的有效解决方案。

也尝试了空密码和所有默认密码。有人可以帮忙吗?

Unable to connect to server:

could not initiate GSSAPI security context: The operation or option is not available
could not initiate GSSAPI security context: Credential for asked mech-type mech not found in the credential handle
FATAL: password authentication failed for user "postgres"

我的/Library/PostgreSQL/13/data/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

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

在此处输入图像描述

标签: postgresqlpsqlpostgresql-13

解决方案


一旦我重新启动计算机,它就会通过我上传的配置得到解决。


推荐阅读