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@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
>