PostgreSQL and PHP

[nicster03]

I'm having trouble connecting to a PostgreSQL database. I am getting an error saying that pg_connect() is an undefined function. Is this because PHP wasn't complied with pgsql support enabled? Thanks for any help!

We're running PHP 4.0.4pl1, Apache 1.3.19, and PostgreSQL 7.0.3 on Linux 2.4.2-2

[mikehoskins]

Yes, this is because PHP wasn't compiled with PostgreSQL support.

Modern distributions make it very easy. Just add the appropriate .RPM (or .DEB to avoid a flame war).

Noting that you are back quite a few versions on PHP, Apache, PostgreSQL, and Linux, might I suggest getting a later distribution, such as Mandrake 8.1, which is optimized out-of-the box and is pretty current?
You'd also do well to upgrade your file system, if you haven't already, to a journaled file system like Reiser-FS (preferred) or ext3 (easier to upgrade and compatible to ext2).

[vincente]

"might I suggest getting a later distribution, such as Mandrake 8.1, which is optimized out-of-the box and is pretty current?"

No you may not :-)
Let's not solve the problem of a squeeky floorboard by tearing down the house and building a new one.

Simply getting a copy of PHP 4.1.1 and compiling/installing that is more than enough to solve this problem.