Re: Regarding PL/SQL with C

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Krishnaprasad <k(dot)krishna(at)hcl(dot)in>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Regarding PL/SQL with C
Date: 2006-02-27 05:20:13
Message-ID: 20060227052013.GA39380@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message mariateresa.ll 2006-02-27 08:07:58 Uppercase initials in Win XP
Previous Message Krishnaprasad 2006-02-27 03:54:33 Re: Regarding PL/SQL with C