Re: [PHP-INSTALL] Can't get PHP to work with postgres

[Barry C . Hawkins]

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/