pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: madhu.harchandani@wipro.com
Cc: pgsql-admin@postgresql.org
Subject: Re: ident authentication problem
Date: Tue, 4 Mar 2008 21:20:42 -0800
Message-ID: <20080304212042.005d789c@jd-laptop> (raw)
In-Reply-To: <20D88322B9D55444A327FEB661C3039008F85E48@HYD-MDP-MBX01.wipro.com>
References: <20D88322B9D55444A327FEB661C3039008F85E48@HYD-MDP-MBX01.wipro.com>

On Wed, 5 Mar 2008 10:01:46 +0530
<madhu.harchandani@wipro.com> wrote:

> 
>  Hello 
>          I am newbie to postgresql I have to make project using
> this . I am learning it but at every step i am getting error . now I
> am stuck with the error 
> 
>    -bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat
>     psql: FATAL:  Ident authentication failed for user "xnat"
> 
> I have made changes in my pg_hba.conf file also but then too this
> error is coming Plz someone help me to get rid of this .

This should help you out:

http://www.postgresqldocs.org/index.php/Client_Authentication

You need to change your pg_hba.conf to not use ident.

Joshua D. Drake

-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (3+ messages)

Message-ID: <20080304212042.005d789c@jd-laptop>
Permalink:  ../20080304212042.005d789c@jd-laptop/
Also on:    postgresql.org/message-id/20080304212042.005d789c@jd-laptop

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, madhu.harchandani@wipro.com
  Subject: Re: ident authentication problem
  In-Reply-To: <20080304212042.005d789c@jd-laptop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox