Edit the file /etc/postgresql/<version>/main/pg_hba.conf and find the following line: local all postgres md5 Edit the line and change md5 at the end to trust and save the file Reload the postgresql service sudo service postgresql reload This will load the configuration files. Now you can modify the postgres user by logging into the psql shell psql -U postgres Update the postgres user's password alter user postgres with password 'secure-passwd-here'; Edit the file /etc/postgresql/<version>/main/pg_hba.conf and change trust back to md5 and save the file Reload the postgresql service sudo service postgresql reload Verify that the password change is working psql -U postgres -W

我这么做是为了解决同样的问题:

在终端上用gedit编辑器打开pg_hba.conf文件:

sudo gedit /etc/postgresql/9.5/main/pg_hba.conf

它会要求输入密码。输入admin登录密码。 这将打开gedit文件。粘贴如下一行:

host  all   all  127.0.0.1/32  trust
just below -

# Database administrative login by Unix domain socket

保存并关闭它。

关闭终端，重新打开并运行如下命令:

psql -U postgres

现在您将进入psql控制台。

现在输入这个来修改密码:

ALTER USER [your preferred user name] with password '[desired password]';

如果它说用户不存在，那么使用CREATE而不是ALTER。

最后，删除粘贴到pg_hba中的特定行并保存它。

我只是在Windows 10上有这个问题，在我的情况下，问题是我只是运行psql，它默认试图登录与我的Windows用户名(“内森”)，但没有PostgreSQL用户的名字，它没有告诉我。

所以解决方案是运行psql -U postgres而不是仅仅运行psql，然后我在安装时输入的密码就可以工作了。

我没能在C:\Program Files\PostgreSQL\14\ data文件夹中找到pg_hba.conf文件，因为根本没有文件夹数据。

我通过使用pgAdmin创建一个新用户并赋予其超级系统管理员权限来解决这个问题。

对于Windows(这对我很有帮助):

这就是我要参考的文档:如何重置PostgreSQL密码?

Open your cmd and go to C:\Program Files\PostgreSQL\12\data. This is usually the right path. You might have it stored somewhere else. Note that, if you have a different PostgreSQL version, there will be a different number. That doesn't matter. Find a pg_hba.conf file and copy it to somewhere else (that way you will have an unmodified version of this file, so you will be able to look at it after we make some changes) Open the pg_hba.conf file (not the backup, but the original) Find the multiple lines that start with host near the bottom of the file: host all all 127.0.0.1/32 md5 host all all ::1/128 md5 host replication all 127.0.0.1/32 md5 host replication all ::1/128 md5 Replace md5 with trust: host all all 127.0.0.1/32 trust host all all ::1/128 trust host replication all 127.0.0.1/32 trust host replication all ::1/128 trust Close this file Go to your search bar on windows and open Services app. Find postgres and restart it. Picture of services app Write cd.. in cmd and then cd bin. Your path should be C:\Program Files\PostgreSQL\12\bin Enter: psql -U postgres -h localhost Enter: ALTER USER postgres with password '<your new password>';Make sure that you include ; at the end “ALTER ROLE” should be displayed as an indication that the previous line was executed successfully Open original pg_hba.conf file and change back from trust to md5 Restart the server with Services app as before

如果你在Windows上，你可以直接运行

net user postgres postgres

并以postgres/postgres用户/密码登录PostgreSQL。