PHP & Postgresql

[eagle862]

Hello all,

I have an interesting problem.

If I install postgresql from rpms I can use phpPgAdmin to connect to the server. I have pgsql.so in my php directory under apache.

If I build my on postgresql I cannot connect to the server with phpPgAdmin, php tells me that it is a call to an undefined function pg_connect().

I read the install file that came in the postgresql source tarball and I saw references to compiling with tcl, tk, and perl etc, but nothing about php.

Do I need to build it with php support built into the postgresql installation.

TIA

John

[[deleted]]

It's the other way around, you need to give PostgreSQL support to PHP.

Check out the installation pages of PHP.

[eagle862]

Ok, I have an Apache, PHP, MySQL, and Postgresql installation.

If I start postgresql from the 7.1.3 version that was installed by RPM's then phpPgAdmin and my internal functions work.

If I start postgresql from the 7.1.3 version that I built from the source tree then phpPgAdmin as well as my internal functions tell me that it is a reference to an undefined function pg_connect().

In either of the above cases I can use psql from the command line and the system works fine.

I noticed that in the source directory there were subdirectories under directory interfaces. These directories are perl5, odbc, and python etc.

Any help or ideas, please

John