对于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(这对我很有帮助):

这就是我要参考的文档:如何重置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

pg_hba.conf (C:\Program Files\PostgreSQL\9.3\data)文件在给出这些答案后发生了变化。在Windows中，对我有用的是打开文件并将METHOD从md5更改为trust:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

然后，我使用pgAdmin III在没有密码的情况下登录，通过“文件→更改密码”菜单修改了用户postgres的密码。

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

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

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

将下面的代码添加到pg_hba.conf文件中。PostgreSQL的安装目录中会出现哪个

hostnossl    all          all            0.0.0.0/0  trust

它将开始工作。