Re: ident authentication problem

On Wed, 5 Mar 2008 10:01:46 +0530
<madhu(dot)harchandani(at)wipro(dot)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