psql: FATAL: password authentication failed for user "xxxx"

From: Steve Taylor <tayl0270(at)flinders(dot)edu(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: psql: FATAL: password authentication failed for user "xxxx"
Date: 2006-01-20 08:36:17
Message-ID: 1137746177.43d0a101e877d@imap.flinders.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I installed PostgreSQL 8.1.2 on Windows XP Pro. I started psql (via the start
menu) and created a user. Then I exited psql using \q. Then I tried to start it
again and got:
psql: FATAL: password authentication failed for user "postgres"
and the command window closed.

I don't understand what is going on. Is this some kind of bug? I have searched
the mailing list archives and found dozens upon dozens of people reporting this
error message, but it's either for a different reason or where it's the same
situation as mine, the message goes unreplied.

The really weird thing is that I did a full uninstall (removed it in Add/Remove
programs AND deleted the directory \Program Files\PostgreSQL) and now psql
won't work AT ALL. I'm just trying to get started. I just want to create ONE
table so I can play around with jdbc.

Why the hell doesn't psql just startup and ask for a username and password? That
makes so much sense that it will never happen.

- Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2006-01-20 08:41:44 Bizgres 0.8 vs. 8.1.2
Previous Message DB Subscriptions 2006-01-20 08:16:59 Create User