pqsql ident authentication failed for user

最新推荐文章于 2023-04-23 17:45:38 发布

原创最新推荐文章于 2023-04-23 17:45:38 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#pgsql

本文详细介绍了如何修改PostgreSQL的pg_hba.conf文件，以设置本地和远程连接的信任级别，包括IPv4和IPv6地址的配置，以及如何允许具有复制权限的用户进行本地复制连接。

/var/lib/pgsql/10/data/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "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                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident

更改为

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "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                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident