Tuesday, November 29, 2011

Postgres error: psql: FATAL: Ident authentication failed for user “postgres”


I am in a hurry so i will just post the solution this time.
CAREFUL Ctrl+c and Ctrl+v users: Remove the angle brackets in names
———————————————————————————
***Restart the postgres server after finishing the changes***
user@desktop: /etc/init.d/postgresql-8.4 restart
———————————————————————————–
user@desktop: psql -Upostgres
FATAL:  Ident authentication failed for user “postgres”
user@desktop: emacs /etc/postgresql/8.4/main/pg_hba.conf
user@desktop: Replace the phrase Ident with trust
Additional details:
If it complains FATAL:  password authentication failed for user “
su root
su postgres
ALTER USER WITH PASSWORD ‘’;
Drop in your qs and i will edit the post a/c.

No comments:

Post a Comment