最近我遇到了无法更改 pgAdmin 中用于连接远程数据库的密码的问题...
在pg_hba.conf
(PostgresSQL 12)中,我具有以下登录功能:
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 0.0.0.0/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
hostnossl all all 0.0.0.0/0 trust
我尝试更改postgres
用户的密码,也尝试更改postgres
数据库中角色的密码没有任何帮助...
有没有办法更改连接到 PostgresSQL 的默认密码?