postgresql – password authentication failed for user postgres

postgresql – password authentication failed for user postgres

If I remember correctly the user postgres has no DB password set on Ubuntu by default. That means, that you can login to that account only by using the postgres OS user account.

Assuming, that you have root access on the box you can do:

sudo -u postgres psql

If that fails with a database postgres does not exists error, then you are most likely not on a Ubuntu or Debian server 🙂 In this case simply add template1 to the command:

sudo -u postgres psql template1

If any of those commands fail with an error psql: FATAL: password authentication failed for user postgres then check the file /etc/postgresql/8.4/main/pg_hba.conf: There must be a line like this as the first non-comment line:

local   all         postgres                          ident

For newer versions of PostgreSQL ident actually might be peer. Thats OK also.

Inside the psql shell you can give the DB user postgres a password:

ALTER USER postgres PASSWORD newPassword;

You can leave the psql shell by typing CtrlD or with the command q.

Now you should be able to give pgAdmin a valid password for the DB superuser and it will be happy too. 🙂

The response of staff is correct, but if you want to further automate can do:

$ sudo -u postgres psql -c ALTER USER postgres PASSWORD postgres;

Done! You saved User = postgres and password = postgres.

If you do not have a password for the User postgres ubuntu do:

$ sudo passwd postgres

postgresql – password authentication failed for user postgres

This was frustrating, most of the above answers are correct but they fail to mention you have to restart the database service before the changes in the pg_hba.conf file will take affect.

so if you make the changes as mentioned above:

local all postgres ident

then restart as root ( on centos its something like service service postgresql-9.2 restart )
now you should be able to access the db as the user postgres

$psql
psql (9.2.4)
Type help for help.

postgres=# 

Hope this adds info for new postgres users

Related posts on post gresql  :

• database – What are PostgreSQL RULEs good for?
• Are there performance issues storing files in PostgreSQL?
• create table – What does regclass mean in Postgresql
• postgresql – How to get First and Last record from a sql query?
• plpgsql – Raising error in postgreSQL
• postgresql – Postgres default sort by id – worldship
• postgresql – SQL OVERLAPS operator problem, how to get rid of it
• postgresql – psql set default statement_timeout as a user in postgres
• postgresql – Heroku download pg:backups how to