postgres ident authentication failed

Question

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?

Answer 1

This article and its comments might help:

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