pgsql：connection failed: connection to server at “::1“, port 5432 failed: : û “postgres“ P(修改密码)

psql: 错误: 连接到"127.0.0.1"上的服务器，端口5432失败：致命错误: 用户 "postgres" Password 认证失败

密码不对，需要重置密码

一.先确保环境变量配置正确
path中

C:\Program Files\PostgreSQL\17\bin

二.修改安装目录里的 data里的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

改成

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

三.ctrl + shift + Esc 找到postgresql-x64-17 重新运行服务

四.运行sql shell(psql)
4.1 连接数据库
psql -U postgres
AI写代码
4.2 修改密码
ALTER USER postgres PASSWORD 'new_password';
AI写代码
五.打开pgAdmin并输入新密码

六.把第二步的东西改回去，重启服务
————————————————

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/qq_53479087/article/details/143277503