Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems using psql--Fatal password authentication failed - Mailing list pgsql-novice

From Guy Flaherty
Subject Re: Problems using psql--Fatal password authentication failed
Date
Msg-id 23d251df0906261531i3803de4bx40da65a01fdcdda0@mail.gmail.com
Whole thread Raw
In response to Problems using psql--Fatal password authentication failed  (Kindra Martinenko <kindramart@yahoo.com>)
Responses Re: Problems using psql--Fatal password authentication failed
List pgsql-novice
Tree view


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 by date:

Previous
From: Kindra Martinenko
Date:
Subject: Problems using psql--Fatal password authentication failed
Next
From: Tom Lane
Date:
Subject: Re: Problems using psql--Fatal password authentication failed