Unable to connect using PSQL - fails to prompt for a password

"Eric Comeau" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
Using "psql", my problem is after my initial connection, the psql utility 
no longer prompts for a password and fails to log in. The initial attempt
successfully prompted for the password and connected to the database. This 
has occurred on two different installations.

I downloaded the Pginstaller beta release and installed PostgreSQL fine on my 
Windows 2000 workstation sp4 desktop. Using the pgAdmin III
GUI and I can successfully create users and databases.

psql -U postgres ecomeau  
psql: FATAL:  Password authentication failed for user "postgres"

psql --version 
psql (PostgreSQL) 8.0.0beta1

I have tried changing the pg_hba.conf to "trust" for local connections but this had no effect.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [email protected] so that your
      message can get through to the mailing list cleanly
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.