Getting PostgreSQL to work with PHP
I have the default Sarge installations of PHP4 and PostgreSQL. But I
can't get PHP to work with PostgreSQL. The php command phpinfo()
shows that it was compiled with the following parameters...
'../configure' '--prefix=/usr' '--with-apxs2=/usr/bin/apxs2' '--with-
config-file-path=/etc/php4/apache2' '--enable-memory-limit' '--
disable-debug' '--with-regex=php' '--disable-rpath' '--disable-
static' '--with-pic' '--with-layout=GNU' '--with-pear=/usr/share/php'
'--enable-calendar' '--enable-sysvsem' '--enable-sysvshm' '--enable-
sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-bcmath'
'--with-bz2' '--enable-ctype' '--with-db4' '--with-iconv' '--enable-
exif' '--enable-filepro' '--enable-ftp' '--with-gettext' '--enable-
mbstring' '--with-pcre-regex=/usr' '--enable-shmop' '--enable-
sockets' '--enable-wddx' '--disable-xml' '--with-expat-dir=/usr' '--
with-xmlrpc' '--enable-yp' '--with-zlib' '--without-pgsql' '--with-
kerberos=/usr' '--with-openssl=/usr' '--with-zip=/usr' '--enable-dbx'
'--with-mime-magic=/usr/share/misc/file/magic.mime' '--with-exec-dir=/
usr/lib/php4/libexec' '--without-mm' '--without-mysql' '--without-
sybase-ct'
It says "--without-pgsql" in there. I'm sure it should say "--with-
pgsql" instead for it to be working. Is there a way I can change this
using apt-get and compiling from source? I know it can be done
manually in a /usr/local directory, but currently PHP is in my /usr/
lib64 directory. I'm kind of hesitant to compile anything outside of /
usr/local unless it is done automatically through apt-get for the
sake of keeping things organised. Any suggestions?
Xavier
Reply to: