CONNETION TO POSTGRESQL

[Anon]

Dear All
How to resolve the following issue, Need some somebody's help Immediatly please.

"Fatal error: Call to undefined function: pg_connect() in /usr/home/www/public_html/add-entry.php on line 10"

Raj Sankar

[Anon]

I'd bet the version of PHP you're using doesn't have the PostgreSQL libraries installed in the build...

If you have the ability, recompile the PHP interpreter with the '--with-pgsql=/path/to/PostgreSQL' option during the configure stage.

If the PHP interpreter resides on a remote machine that you don't have access to, see if the web-meister can build you a new PHP module; if you built the module from the sources, make sure this option is set when you compiled the interpreter.

If you downloaded a pre-compiled binary version (say you don't have a compiler, or whatever), remember that support for PostgreSQL is not enabled by default. You can either find a PHP binary with PostgreSQL support built in, or build your own interpreter from the source code.

[Anon]

Thank You,
My unix Knowledge is less than beginner. How ever I issued the commands the following way.
1. cd /usr/local/src/apache_1.3.24
2. ./configure --prefix=/usr/local/apache
3. cd /usr/local/src/php-4.2.1
4. ./configure
--with-apache=/usr/local/src/apache_1.3.24
--with-pgsql=shared
--enable-track-vars
--with-xml

5. make;make install

6. cp php.ini-dist /usr/local/lib/php.ini

Raj Sankar..