Fatal error: Call to undefined function pg_connect
php, wamp, windows
Solution
Apache 2.2.X configuration
Add the next line to the Apache 2.2.x httpd.conf configuration:
LoadFile "C:/Program Files/PostgreSQL/{version}/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 the following two lines in the php.ini configuration file. By 'Enable' i mean, remove trailing ; (semicolon). By these, you un-comment the line.
extension=php_pdo_pgsql.dll
extension=php_pgsql.dll
Restart WAMP
Test by adding this in your index.php
echo extension_loaded('pgsql') ? 'yes':'no';
(source: http://www.plaatsoft.nl/wamp-postgresql-integration/)
Problem
I am using Windows 7, php 5.3.5 and WAMP server. I have two php files: trigger.php and background.php. I want to run background.php as a background process. I have to call this file from trigger.php. To accomplish this I used below method. I included following code in trigger.php to make background.php to process in background. ``` $handle = popen('start /b C:\wamp\bin\php\php5.3.5\php.exe C:\wamp\www\email3.php','r'); ``` in background.php I have the follwing code to connect to database. ``` $conn_string = "host=localhost port=5432 dbname=tagbase user=postgres password=postgres"; ``` now, on parsing this line am getting the follwing error : Fatal error: Call to undefined function pg_connect() in C:\wamp\www\background.php on line 3 Call Stack: 0.0002 322792 1. {main}() C:\wamp\www\background.php:0 By searching in in the internet I found some solutions, and made changes as recommended below in php.ini, ``` uncommented, extension=php_pdo_pgsql.dll, uncommented, extension=php_pgsql.dll, uncommented, extension_dir = "c:/wamp/bin/php/php5.3.5/ext/", ``` also I do have php_pdo_pgsql.dll and php_pgsql.dll files in `c:/wamp/bin/php/php5.3.5/ext/` folder. Any suggestions are appreciated.