Pages

Tuesday, July 24, 2012

FATAL: password authentication failed for user postgres


If you face this error on trying to use psql, the following steps should fix it:

By default, postgres creates a user named 'postgres'. We log in as postgres, and give a password.

$ sudo -u postgres psql
\password
Enter password: ...
...

Now try again. The above steps work for a fresh install of postgres 9.1 and 8.4 on Ubuntu 12.04.

No comments:

Post a Comment