Re: PostgreSQL connect error

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(at)rp-online(dot)de>
To: "devi" <devi(at)visolve(dot)com>; <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>