Skip site navigation (1) Skip section navigation (2)

Re: Problems using psql--Fatal password authentication failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guy Flaherty <naoshika(at)gmail(dot)com>
Cc: Kindra Martinenko <kindramart(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems using psql--Fatal password authentication failed
Date: 2009-06-26 22:35:11
Message-ID: 10531.1246055711@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Guy Flaherty <naoshika(at)gmail(dot)com> writes:
> On Sat, Jun 27, 2009 at 5:14 AM, Kindra Martinenko <kindramart(at)yahoo(dot)com>wrote:
>> 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".
>> 
>> [command prompt line:\]psql U-Kindra
>> password (trust level is set at md5): ******
>> FATAL: password authentication failed for User "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.

I'm wondering what the *actual* username is (we see three different
renderings of it above), and whether it contains any funny characters
that pgAdmin will quote for you but cause trouble on a shell command
line.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: ANdreas WenkDate: 2009-06-27 12:43:14
Subject: Re: Full Text Search - Influenceing the creation of tsvector
Previous:From: Guy FlahertyDate: 2009-06-26 22:31:39
Subject: Re: Problems using psql--Fatal password authentication failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group