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