Call to undefined function pg_connect() - Wamp

Question

I want to connect to PostgreSQL, Im using wamp 64 bit.

I have here

Apache 2.4.2
PHP 5.4.3
Mysql 5.5.24

I also uncomment in php.ini the php_pgsql and php_pdo_pgsql. but i can't connect , It gives me error like this :

Error suppression ignored for ( ! ) Fatal error: Call to undefined function pg_connect()

Is there anybody know the solution regarding on my problem. I just need it badly.

Thank you .

possible duplicate of [Fatal error: Call to undefined function pg\_connect()](http://stackoverflow.com/questions/7438059/fatal-error-call-to-undefined-function-pg-connect) — Lawrence Cherone, Sep 20 '13 at 02:19
You didn't mention libpq.dll. The php dlls can't be loaded without it. See this other duplicate: http://stackoverflow.com/questions/14849010 — Daniel Vérité, Sep 20 '13 at 14:04

score 24 · Answer 1 · edited May 05 '16 at 17:28

24

Open php.ini
Find ;extension=php_pgsql.dll and remove the semicolon at the beginning
Find ;extension=php_pdo_pgsql.dll and remove the semicolon at the beginning
Save the file
Restart apache

Hope this helps

edited May 05 '16 at 17:28

Chris Forrence

10,042
11
48
64

answered Sep 20 '13 at 05:27

Abdul Hamid

3,222
3
24
31

1

You also need to uncomment the line: extension="pgsql.so" – Ronald Araújo Jun 15 '15 at 00:19
Excellent. This was the only thing I needed to do. I was trying to connect to a remote PostgreSQL and this method worked. Thank you. – Max Collao Oct 26 '18 at 22:15

score 5 · Answer 2 · answered Sep 24 '13 at 03:28

5

i Solve my problem in putting a LoadFile in httpd.conf

LoadFile "location\libpq.dll";

First i uncomment the extension=php_pgsql.dll and extension=php_pdo_pgsql.dll then i put the LoadFile in httpd.conf then restart Apache and Wamp.

Thank you guy's

answered Sep 24 '13 at 03:28

student

181
1
2
8

score 4 · Answer 3 · edited Aug 14 '14 at 04:37

I think this will help you.

Right click on my computer and select properties.
Click on advance system settings
On the system properties window click “environment variables”
Look for system variables frame and click “Path” variable
Click the “edit” button
Change the variable value by adding your php root path. Mine looks like this:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;c:\wamp\bin\php\php5.3.0\
Just added your php root path at the end.
Restart your wampserver and check mark the pdo_pgsql and php_pgsql extension using the wamp server menu or by editing your php.ini ; just remove the remark for the above extensions.

score 1 · Answer 4 · answered Jun 27 '14 at 02:06

1

Copy libpq.dll from php folder (ex.: C:\wamp\bin\php\php5.5.12) to apache bin folder (ex.: C:\wamp\bin\apache\apache2.4.9\bin) then restart apache and be happy!

answered Jun 27 '14 at 02:06

dap.tci

2,455
1
20
18

score 0 · Answer 5 · answered Jan 13 '15 at 16:36

0

In case any of that doesnt work, try this in your httpd.conf file under apache...

configure the path to php.ini

PHPIniDir "c:/wamp/bin/php/php5.5.12"

answered Jan 13 '15 at 16:36

ohjeeez

559
4
6

Call to undefined function pg_connect() - Wamp

5 Answers5

configure the path to php.ini

Linked