Getting PostgreSQL 9.0.4 module for PHP-5.3.8 on Slackware 13.37

I wanted to play around with PostgreSQL on the test server at work today, and found the slackpack over at LinuxPackages. I was very pleased that I wouldn’t have to compile PostgreSQL from source, as such complex apps will take more time than I would like to invest.

Anyway, once I’ve installed the package, and initialised the database, I decided to give phpPgAdmin a whirl on my freshly baked PostgreSQL installation, but when I try to use it I get an error message telling me that I have not compiled proper database support into my PHP installation.

I checked out my phpinfo(); and sure enough, Slackware‘s package was not built with the --with-pgsql option.

Most of my googling results mention that the only solution is to recompile PHP from scratch, including the --with-pgsql flag. Hmm, I'm really hate to replace my original PHP installation which was done in the “proper” way, ie. via the available slackpack. Who know what the hell I can possibly misconfigure and break!

Anyway, here’s how I got my PostgreSQL to work with the default Slackware PHP installation:

1. Download the PHP source code (be sure to use the PHP version that’s the same with your installation).
2. Unpack the archive and go to the source directory (well, duh!).
3. Run ./configure ---with-pgsql=shared,/usr (I know it’s too short, but just trust me on this, OK).
4. Run make.
5. Don’t run make install or checkinstall (if you’re using checkinstall, that is) like you usually would.
6. Just copy /modules/pgsql.so to /usr/lib/php/extensions.
7. As root, edit your /etc/apache/php.ini file and look for a line saying extension=mysql.so
8. Under this line type in: extension=pgsql.so and save the file.
9. Restart your apache service by running /etc/rc.d/rc.httpd restart (again, as root) to activate PostgreSQL support in PHP.

Hope this helps other Slackers as well as Linux users in general.

In short
You need only the PHP pgsql.so module,  verify with pkgtool what's your PHP version, mine is 5.3.8 (Slackware 13.37). 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.3.8.tar.bz2/from/a/mirror

replacing the version number

http://www.php.net/get/.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 -v modules/pgsql.so /usr/lib/php/extensions/

Open with an editor /etc/httpd/php.ini

extension=pgsql.so

#mcedit /etc/https/php.ini

and add this line

extension=pgsql.so

Restart apache

#/etc/rc.d/rc.httpd restart

Done

you can download my PostgreSQL 9.0.4 module for PHP-5.3.8 on Slackware 13.37 HERE

Referensi : Referensi 01 Referensi 02