Re: Problems using psql--Fatal password authentication failed

Поиск
Список
Период
Сортировка
От Guy Flaherty
Тема Re: Problems using psql--Fatal password authentication failed
Дата
Msg-id 23d251df0906261531i3803de4bx40da65a01fdcdda0@mail.gmail.com
обсуждение исходный текст
Ответ на Problems using psql--Fatal password authentication failed  (Kindra Martinenko <kindramart@yahoo.com>)
Ответы Re: Problems using psql--Fatal password authentication failed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice


On Sat, Jun 27, 2009 at 5:14 AM, Kindra Martinenko <kindramart@yahoo.com> wrote:
Thanks Guy--I'll try the datestyle thing, but ...

Now, yet another problem I am having is being able to launch the psql command line.  It gives me a "FATAL: password authentication failed for User "Kindra".

This is the first time I have even touched psql, I usually work straight from PGAdmin III. When I type this after the prompt, it just keeps returning the same error, although I can access PGAdmin III with this password?  I am confused.

[command prompt line:\]psql U-Kindra
password (trust level is set at md5): ******
FATAL: password authentication failed for User "Kindra


I launched the pg_hba.conf file, and attempted to set the trust level to "trust", however, Windows (being Windows)...would not allow me to save the .conf file? Does anyone have a workaround for FATAL password authentication errors and .conf file modification in a Windows environment?

Thanks!

Kindra

Hmm, I have no experience with psql on windows. I am assuming you are using pgAdmin III on the server and not connecting to another machine. Perhaps you need to specify the actual database you are connecting to with psql?  Maybe try with -D to specify the database.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Kindra Martinenko
Дата:
Сообщение: Problems using psql--Fatal password authentication failed
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problems using psql--Fatal password authentication failed