Search Postgresql Archives

Re: PostgreSQL connect error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux