Обсуждение: Unable to connect using PSQL - fails to prompt for a password

Поиск
Список
Период
Сортировка

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

От
"Eric Comeau"
Дата:
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.