Re: Can't get PHP to work with postgres

On Nov 16, 2003, at 8:51 PM, Bengt Hammarlin wrote:

This is what I do:

cd httpd-2.0.48/                 (apache)

configure make cd ../postgresql-7.3.4/ configure make make install cd ../php-4.3.4/ ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-postgres make make install libtool --finish {path}/php-4.3.4/libs Then I tar up /usr/local/apache2 and copy to my target machine that does not have compilers and stuff. for good measure i toss in /usr/local/postgres as well When trying my page (that works well in a install-from-an-old-RH-CD environment) I get Fatal error: Call to undefined function: pg_pconnect() in {other-path}/connect_db.php on line I would very much appreciate some good advice. Bengt Hammarlin Bengt,

It looks like you might not have the PostgreSQL configure switch correct. If you issue: $>./configure --help > phpConfigOptions.txt and search through the text of that file that is produced, you will find:

  --with-pgsql[=DIR]      Include PostgreSQL support.  DIR is the PostgreSQL
                          base install directory, defaults to /usr/local/pgsql.

I used that and my PostgeSQL support is working. Best wishes, -- Barry C. Hawkins All Things Computed site: www.allthingscomputed.com weblog: www.allthingscomputed.com/blog/