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
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