PHP and Postgresql

[Anon]

Hi all,
I tried to connect to postegresql from php3 using the following code:
<?hph
$conn = pg_connect("host=mycompany.com dbname=mydb");
?>

But I got the following error message:
Fatal error: call to unsupported or undefined function pg_connect()

I use PHP version 3.01.2, Apache 1.3.9 on Red Hat 6.2. Any suggestions? Thanks,
Nasir

[Anon]

use the php-command: phpinfo();
to check that your php-module contains postgres support.

Well, that would be a nice exercise, but you do not really need to do that:

The error-message

call to unsupported or undefined function pg_connect()
actually says that your php doesn't have postgres support.

So why don't start downloading the php-source, typing:
tar xvfz ...
./configure --with-apxs --with-pgsql
make
make install

If you're lucky you wont have to recompile apache. Today I had the same problem and I was succesfull only by replacing libphp4.so in the directory /usr/lib/apache. Actually make install did that. Maybe you want to backup your old libphp4.so. Restarting Apache should do the job!

Have fun,

Rik