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?