pgsql：connection failed: connection to server at “::1“, port 5432 f
psql: 错误: 连接到"127.0.0.1"上的服务器，端口5432失败：致命错误: 用户 "postgres" Password 认证失败密码不对，需要重置密码
一.先确保环境变量设置正确
path中
L:\myweb\database\pgsql\pgsql\bin 二.修改安装目录里的 data里的pg_hba.conf 文件
# TYPEDATABASE 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 改成
# TYPEDATABASE 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 4.2 修改密码
ALTER USER postgres PASSWORD 'new_password'; 五.打开pgAdmin并输入新密码
https://i-blog.csdnimg.cn/direct/bdf0675a629b4892963d79e943ca8a87.png
六.把第二步的东西改回去，重启服务
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]