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@xxxxxxxxxxxx>
To: "devi" <devi@xxxxxxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, March 10, 2009 2:53 PM
Subject: Re: 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general