After upgrading debian to version 6, postgres was upgraded to 8.4. I had to create a new user, new database. Well, this didn't go well. I had previously backed up my database. Now after restoring my postgres db, I had the error above.
"auth_user" already exists. I have no idea how to fix this. Any help is appreciated.