Thread: ident authentication problem

ident authentication problem

From
Date:

 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 .

Thanx
Regards
Madhu Harchandani

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

Re: ident authentication problem

From
"Joshua D. Drake"
Date:
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


Attachment