Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm trying to set up django on a fresh Ubuntu VM. I'm following the tutorials along until I get to this:

psycopg2.OperationalError: FATAL: Ident authentication failed for user "postgres"

The Ubuntu user "postgres" has had its password set to 123456:

sudo su postgres -c passwd

Using pdadmin, I connect to the pg instance at localhost, go into Login Roles, right click on the user 'postgres' and set the password to 123456. I then click OK and exit pgadmin3.

But, even after doing all this,

psql -U postgres -W

rejects the password I have given it. Django also continues to give me the same error even though settings.py has been setup with the correct info.

Anyone have any ideas?

share|improve this question

2 Answers 2

up vote 8 down vote accepted
+25

This article and its comments might help:

“FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas

share|improve this answer
    
Thank you. My google-fu was failing me, apparently. –  Amy Aug 25 '10 at 18:09

change IPv4 local connections to trust in pg_hba.conf.

# IPv4 local connections:
host    all         all         127.0.0.1/32          trust

i hope it helps you...

share|improve this answer
1  
This is allow ALL local users connect without passwords to Postgres. This is bad idea –  b1- Oct 29 '12 at 6:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.