Re: Problems using psql--Fatal password authentication failed

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