'password authentication failed for user "postgres"'

Question

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it before a couple of times without this problem. What should I do? And what happens?

psql -U postgres -h localhost -W
Password for user postgres: 
psql: FATAL:  password authentication failed for user "postgres"
FATAL:  password authentication failed for user "postgres"

In my case the connection fails because the password is too complex ... — JJD
– JJD, Commented Feb 18, 2015 at 17:21
Be sure to read all the way down this page. I had to do several things to get this working. First, the ALTER step, then editing my pg_hba.conf file, then restarting postgres. — elrobis
– elrobis, Commented Oct 28, 2015 at 19:52
Possible duplicate of How do I login and authenticate to Postgresql after a fresh install? — Evan Carroll
– Evan Carroll, Commented Apr 30, 2018 at 19:37
Also ensure that you have not two Postgres instances running: one on Windows, one in Docker. Docker did not report to me that the port was already taken. So, the tool connected to the Windows machine Postgres, whereas in the Docker postgers, everything was fine. — koppor
– koppor, Commented Sep 25, 2019 at 10:39
How is this a programming question? It may be system administration, but that's a separate discipline. — Charles Duffy
– Charles Duffy, Commented Feb 8, 2024 at 1:17

Vaun Drex · Accepted Answer · 2024-09-04 06:09:38Z

0

For me I was using .Net Aspire hosting, so docker, with a data volume and I had changed the password since the first time the container was created. So the solution was to delete the docker volume.

answered Sep 4, 2024 at 6:09

Vaun Drex

1

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

-2

I hope this will help you short of time. You can change the password of postgres sql by using bellow command.

Command

sudo -u postgres psql

And next you can update the password

Command

Alter user postgres password 'YOUR_NEW_PASSWORD';

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 2, 2018 at 10:58

Sonu patel

3391 silver badge8 bronze badges

1 Comment

L. Guthardt Over a year ago

Your answer just contains information, that has already been added: stackoverflow.com/a/7696398/8283469

Collectives™ on Stack Overflow

'password authentication failed for user "postgres"'

32 Answers 32

Comments

Command

Command

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

32 Answers 32

Comments

Command

Command

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related