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
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。