WAMP + PostgreSQL integration

If you want to extend an existing Windows WAMP installation with a PostgreSQL database execute the following steps:

Apache 2.2.X configuration
Add the next line to the Apache 2.2.x httpd.conf configuration:
LoadFile “C:/Program Files/PostgreSQL/9.1/bin/libpq.dll”

Above line must be entered before the next line.
LoadModule php5_module “c:/wamp/bin/php/php5.2.11/php5apache2_2.dll”

PHP 5.2.X Configuration
Enable (remove trailing ; character) the following two lines in the php.ini configuration file.

Restart WAMP
Restart the wamp (apache, php and mysql) software.

Create the following test.php file and place it in the apache www root directory:

echo extension_loaded('pgsql') ? 'yes':'no';

When the php file is executed ( in apache the following information must be showed on screen.


Leave a Reply

Your email address will not be published. Required fields are marked *