Configure PHP and PostgreSQL on Windows

Question

I'm installing PHP, Apache and PostgreSQL Manually

PHP and Apache now is connected, but PostgreSQL is not connected to PHP.

i test by using phpinfo();

i also configure in php.ini like this :

extension=php_pgsql.dll
extension=php_pdo_pgsql.dll

But why it's not work.

Thanks

What does "not connected to PHP" mean? That you don't see the Postgres module in the output of phpinfo() ? Do you get any error messages? — David Precious
– David Precious, Commented Jun 29, 2011 at 9:50

Cees Timmerman · Accepted Answer · 2017-04-25 08:17:22Z

10

This tutorial worked for me:

The PHP extension will look for libpq.dll which is found of your PostgreSQL installation. The simple fix is to add the path than contains that file to your environment PATH.

edited Apr 25, 2017 at 8:17

Cees Timmerman

20.3k11 gold badges99 silver badges138 bronze badges

answered Jun 29, 2011 at 10:25

Igor Hrcek

7451 gold badge6 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Erik Verheij · Accepted Answer · 2017-08-30 16:01:29Z

3

I had the same issue with PHP7 and Apache 2.4 on Windows 10. For me the solution was to add the following line to httpd.conf;

LoadFile "C:/php7/libpq.dll"

This also means that it's not required to have PostgreSQL installed if you just want to connect a PostgreSQL database that's not running on your machine.

answered Aug 30, 2017 at 16:01

Erik Verheij

3032 silver badges7 bronze badges

Comments

aorlando · Accepted Answer · 2013-01-25 15:11:33Z

1

1) Installing PostgreSQL for Windows

2) add to your enviroment variable "PATH" the bin folder of PostgreSQL installation: C:\Program Files\PostgreSQL\9.2\bin; (for example)

answered Jan 25, 2013 at 15:11

aorlando

6786 silver badges21 bronze badges

Comments

Mohammad Yusuf · Accepted Answer · 2014-11-02 13:53:32Z

1

Assuming you have installed PostgreSQL and your WAMP installation is on c:\wamp, you will need to copy c:\wamp\bin\php\php5.3.9\libpq.dll to c:\wamp\bin\apache\Apache2.2.11\bin

Make sure you also have the following files C:\wamp\bin\php\php5.3.9\ext\php_pdo_pgsql.dll and C:\wamp\bin\php\php5.3.9\ext\php_pgsql.dll

Also, make sure you have enabled the above 2 files as extensions, either via the WAMP menu (click on WAMP icon on taskbar, PHP, PHPExtensions, find the above 2 and 'check' them)

Please note that php5.3.9 and Apache2.2.11 refer to my specific PHP and Apache versions. Adjust those to suit your installation.

That's it!

answered Nov 2, 2014 at 13:53

Mohammad Yusuf

192 bronze badges

Comments

James Risner · Accepted Answer · 2022-10-29 15:49:35Z

1

This worked for me on Windows:

Found php.ini in php folder.
Found this line and removed “;”.
```
;extension=php_pgsql.dll
```

edited Oct 29, 2022 at 15:49

James Risner

6,09711 gold badges33 silver badges60 bronze badges

answered Oct 25, 2022 at 10:14

Alex

314 bronze badges

Comments

rtfmpliz · Accepted Answer · 2020-03-26 11:35:53Z

0

in my case there are 2 php.ini, I had to uncomment extension pdo_pgsql in both php.ini

in php folder
in apache folder

both inside in wamp folder

answered Mar 26, 2020 at 11:35

rtfmpliz

3592 silver badges8 bronze badges

Comments

tno2007 · Accepted Answer · 2022-03-31 17:08:29Z

0

If you are using PHP in IIS, using PHP Manager, enable this extension:

php_pgsql.dll

answered Mar 31, 2022 at 17:08

tno2007

2,20829 silver badges19 bronze badges

Comments

Ram Chander · Accepted Answer · 2023-07-31 21:18:05Z

0

In my case, first I checked the location of php.ini file using this command-

php -i | find /i "Configuration File"

After that I followed that location and find the line

;extension=pdo_pgsql

Finally I remove the comment operator and the line marked as like this

extension=pdo_pgsql

edited Jul 31, 2023 at 21:18

Ram Chander

1,69011 gold badges26 silver badges48 bronze badges

answered Jul 25, 2023 at 18:09

Ariful Hoque

11 bronze badge

Collectives™ on Stack Overflow

Configure PHP and PostgreSQL on Windows

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related