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
|
| Список | pgsql-novice |
On Sat, Jun 27, 2009 at 5:14 AM, Kindra Martinenko <kindramart@yahoo.com> wrote:
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.
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-Kindrapassword (trust level is set at md5): ******FATAL: password authentication failed for User "KindraI 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 по дате отправления: