psql: FATAL: password authentication failed for user "postgres" psql server version 9.3

Question

I am getting the password authentication failed. I've tried with METHODS peer, trust, ident. Made sure to restart or reload the conf.

sudo -u postgres psql -U postgres

Password for user postgres: psql: FATAL: password authentication failed for user "postgres"

sudo service postgresql reload

My pg_hba.conf:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
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

Are you sure you're editing the config that corresponds to the DB that you're running? — Craig Ringer
– Craig Ringer, Commented Nov 12, 2014 at 2:03
Yes, because earlier when I was able to connect to the DB and I had found the config location by running postgres=# SHOW hba_file; hba_file ------------------------------------- /var/lib/pgsql/9.3/data/pg_hba.conf (1 row) In Centos 6 Linux 64 — Aditya Mittal
– Aditya Mittal, Commented Nov 12, 2014 at 8:50
Thanks for your comment, I figured it out; somehow there is another config in the data directory outside 9.3 which is running now — Aditya Mittal
– Aditya Mittal, Commented Nov 12, 2014 at 8:55
@AdityaMittal: Where was the other config located? I have a similar problem. — krm
– krm, Commented Nov 19, 2015 at 15:00
@AdityaMittal: I can't edit my previous comment anymore, therefore I add a second one with additional questions and information: Did you mean that the database uses a different config file than stated by the path returned by "SHOW hba_file;"? In my case when I ask the database "SHOW hba_file;", then I get the path to the pg_hba.conf file also in a similar directory (/var/lib/pgsql/9.4/data/pg_hba.conf). I edited this file, but it didn't help. How did you solve your problem? — krm
– krm, Commented Nov 19, 2015 at 15:08

bhavik · Accepted Answer · 2022-05-26 05:08:16Z

0

follow this step for ubuntu/linxs

-> sudo -u postgres psql

-> postgres=#

After that right

->postgres=# \password

Enter new password for user “postgres”:

Enter it again:

Now check, the new password is working successfully.

edited May 26, 2022 at 5:08

answered May 26, 2022 at 5:06

bhavik

193 bronze badges

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

Collectives™ on Stack Overflow

psql: FATAL: password authentication failed for user "postgres" psql server version 9.3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related