Re: Regarding PL/SQL with C - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Regarding PL/SQL with C
Date
Msg-id 20060227052013.GA39380@winnie.fuhr.org
Whole thread Raw
In response to Re: Regarding PL/SQL with C  (Krishnaprasad <k.krishna@hcl.in>)
List pgsql-novice
On Mon, Feb 27, 2006 at 09:24:33AM +0530, Krishnaprasad wrote:
>          thanks for ur input... I tried with *PQconnectdb* also. But
> still it is showing connection error
> when I tried with PQErrorMessage it is coming as below.
>
> *FATAL:  IDENT authentication failed for user "postgres" ...

What operating system user is the program running as?  What connect
string are you using now (the previous one was erroneous)?  Does
pg_hba.conf have an ident map that would allow the operating system
user to connect to the specified database as the specified database
user?

If you're not sure how to check pg_hba.conf then see the "Client
Authentication" chapter in the documentation, in particular the
"Ident-based authentication" section:

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
http://www.postgresql.org/docs/8.1/interactive/auth-methods.html#AUTH-IDENT

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Krishnaprasad
Date:
Subject: Re: Regarding PL/SQL with C
Next
From: mariateresa.ll@bresciaonline.it
Date:
Subject: Uppercase initials in Win XP