Re: psql - password authentication failed for user "singh09721"

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Gaurav Singh" <singh09721(at)itc(dot)nl>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql - password authentication failed for user "singh09721"
Date: 2010-08-10 17:52:00
Message-ID: 4C614B70020000250003443A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Gaurav Singh <singh09721(at)itc(dot)nl> wrote:

> The Postgres server is up and running but when I call psql it
> gives fatal error saying "password authentication failed for user
> singh09721".

You are probably not specifying a database user ID for psql to use,
so it is defaulting to your OS login ID. Do you get in if you try?:

psql postgres postgres

You might want to browse through the documentation:

http://www.postgresql.org/docs/8.4/interactive/index.html

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kasia Tuszynska 2010-08-10 19:08:20 postgres function does not handle PUBLIC - expected?
Previous Message Gaurav Singh 2010-08-10 17:31:33 psql - password authentication failed for user "singh09721"