Hi ,
As john suggested, i tried setting up the env .. but that dosen't help out.
I tried with IP, instead of localhost in pg_hba.conf.. just trail & error
approach...
Now.. i'm getting the error as "FATAL: role "apache" does not exist.."..
Can U help me out here!!
Thanks
DEVI.G
----- Original Message -----
From: "Thomas Pundt" <mlists@rp-online.de>
To: "devi" <devi@visolve.com>; <pgsql-general@postgresql.org>
Sent: Tuesday, March 10, 2009 2:53 PM
Subject: Re: [GENERAL] PostgreSQL connect error
> devi schrieb:
>> Hi Friends,
>> I wrote a sample php program that connects to PostgreSQL DB.
>> ==> I was able to run the PHP program from the command prompt as
>> postgres user & not as anyother user
>> $ php pgsql.php
>> ==> I was not able execute the same file from the web browser. FATAL
>> ERROR- undefined function pg_connect().
>> How to resolve this issue? Please help.
>> Thanks
>> DEVI.G
>
> Apparently your php CLI binary has support for PostgreSQL compiled in,
> your web server not. Resolving this highly depends on your platform;
> it might be as easy as installing an RPM and restarting the web server,
> or you needing to recompile PHP with PostgreSQL support compiled in.
>
> Ciao,
> Thomas
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
