Re: Problems using psql--Fatal password authentication failed

On Sat, Jun 27, 2009 at 5:14 AM, Kindra Martinenko <kindramart(at)yahoo(dot)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.