Postgresql support for PHP in Slackware

Slackware lacks postgresql support, so porting PHP webapps on a new server is a trouble. This article solved my problem in less then ten minutes.

http://www.heritage-tech.net/165/getting-additional-php-modules-without-totally-recompiling/

In short

You need only the PHP pgsql.so module

 Verify with pkgtool what's your PHP version, mine is 5.2.6 (Slackware 12.1)

Download in /usr/local/src the PHP sources, I take them from php.net website using this link

http://www.php.net/get/php-5.2.8.tar.bz2/from/a/mirror

replacing the version number

http://www.php.net/get/php-5.2.6.tar.bz2/from/a/mirror

extract the compressed tarball, dive into the newly created directory and, as article say, type

./configure --with-pgsql=shared,/usr

then

make

Now copy the module in the corrected directory

cp modules/pgsql.so /usr/lib/php/extensions/

open with an editor /etc/httpd/php.ini and add this line

extension=pgsql.so

approx at line 652

restart apache

/etc/rc.d/rc.httpd restart

done

other useful references

	https://www.linuxquestions.org/questions/slackware-14/php-extension-for-postgresql-383312/
	http://dan.drydog.com/apache2php.html
	http://bytes.com/groups/postgresql/420655-php-slackware

compiled on slackware 13.0 postgresql 8.4.1 gcc-4.3.3

compiled on slack12.0 postgresql 8.2.4 gcc-4.1.2