Integration of postgreSQL on WAMP

Question

I have just installed the postgreSQL on windows 7. I am trying to integrate postgreSQL with WAMP server. For this i have done the following changes in httpd.conf and php.ini file

1 LoadModule c:/path to libpq.dll in httpd.conf and then

2 extension=php_mod_pgsql.dll, extension=php_pgsql.dll -- enable(reemove ;) in php.ini

If I do the above changes the localhost does not work.

If I do the second changes the localhost work but does not load the libpq.dll.

I checked the pgsql by php script by this

<?php
 echo extension_loaded('pgsql') ? 'yes':'no';
 ?>

The script shows "yes", but apache is not loading the libpq.dll. Now what i should do for load the postgreSQL into the Apache2.2* (wamp)

score 41 · Answer 1 · edited Jan 18 '19 at 00:17

41

After installation of PostgreSQL, you need to copy libpq.dll from wamp\bin\php\phpX.X.X to wamp\bin\apache\Apache2.2*\bin . And restart the Wampserver.
Download phpPgAdmin here.
Extract phpPgAdmin-5.1.zip in C:\wamp\apps So the path will be, C:\wamp\apps\phpPgAdmin-5.1.

Create a file called phppgadmin.conf in C:\wamp\alias. And copy paste the following :

Alias /phppgadmin "C:/wamp/apps/phpPgAdmin-5.1/" 

<Directory "C:/wamp/apps/phpPgAdmin-5.1/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
  Allow from all
</Directory>

Left Click on the Wampserver Tray icon. Navigate to PHP > PHP extension. Then enable this
```
a. php_pgsql 
b. php_pdo_pgsql extension.
```
Open C:\wamp\apps\phpPgAdmin-5.1\conf\config.inc.php,

a. find $conf['servers'][0]['host'] = ''; change to $conf['servers'][0]['host'] = 'localhost';
b. find $conf['extra_login_security'] = true; change true to false
Restart All service
Go to http://localhost/phppgadmin/ and try to login.
Default Login credentials are
- Username = "postgres"
- Password = "root"

references :

edited Jan 18 '19 at 00:17

Pankaj

401
1
6
16

answered Sep 14 '13 at 17:10

rails_id

8,120
4
46
84

Thanks buddy it works! But what is the login credentials for login to phppgadmin? – Raj Mar 18 '15 at 05:03
Hey I salved this buddy I got the default password too: Username = "postgres" Password = "root". – Raj Mar 18 '15 at 05:43
1

This is still extremely helpful information! Thanks for answering this question. It solved all of my initial problems, but now I get a 403 error when I try to navigate to http://localhost/phppgadmin/ Any ideas how to solve it? – KingRichard Nov 07 '15 at 20:15
1

nvm. found it [here](http://stackoverflow.com/questions/24414358/http-localhost-phppgadmin-403-forbidden) – KingRichard Nov 07 '15 at 20:18
2

make sure your paths for WAMP are right. Mine is in `c:/wamp64/` – Chad Aug 30 '17 at 15:36
i am unable to copy the libpq.dll to the bin folder, it says the the file is being used,please close the folder.although all folders are closed – sid.s Oct 02 '18 at 10:50
@sid.s: copying libpq.dll is showing that error because its used by a symlink (symbolic link) which might present in the wamp\bin\apache\Apache2.2*\bin. removing or renaming this will allow you to copy in the folder. – Pankaj Jan 19 '19 at 06:02
I added "Require local" to the `phppgadmin.conf` file in `C:\wamp64\alias` to enable the use of phpPgAdmin (Source: [https://stackoverflow.com/questions/24414358/http-localhost-phppgadmin-403-forbidden](https://stackoverflow.com/questions/24414358/http-localhost-phppgadmin-403-forbidden)) – crwang Nov 11 '20 at 22:30

score 12 · Answer 2 · answered Feb 24 '15 at 17:45

12

Thank you. These instructions worked once I also added 'Require local' to the phppgadmin.conf file:

Alias /phppgadmin "C:/wamp/apps/phpPgAdmin-5.1/" 

<Directory "C:/wamp/apps/phpPgAdmin-5.1/">
    Require local
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
  Allow from all
</Directory>

answered Feb 24 '15 at 17:45

Jessica Gramp

121
1
2

Adding 'Require local' helped me too. Thanks Jessica. – Pankaj Dec 27 '18 at 17:38

score 1 · Answer 3 · answered Mar 22 '15 at 14:44

Don't forget that WAMP has two php.ini files. One in Apache directory, one in php directory (bin\php\php5.X.X). Wampserver Tray manages the one in Apache directory.

To be able to run php cli tools (e.g php artisan), you need to uncomment the php_pgsql and php_pdo_pgsql in the php.ini in php directory.

score 1 · Answer 4 · edited Jul 10 '15 at 08:35

1

it worked thank you

Alias /phppgadmin "C:/wamp/apps/phpPgAdmin-5.1/" 

<Directory "C:/wamp/apps/phpPgAdmin-5.1/">
    Require local
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
  Allow from all
</Directory>

edited Jul 10 '15 at 08:35

Sebastien C.

4,649
1
21
32

answered Jul 10 '15 at 04:15

Sammee Mushtaq Bazaz

21
2

score 0 · Answer 5 · answered Apr 23 '13 at 12:49

Probably the best place to start is with the msdn docs. It looks like the simplest fix is to set the %PATH% environment variable system-wide to include the path to libpq.dll.

Note that %PATH is searched last, so if a libpq is ever put into the system directory or the Apache directory it will be caught first.

Pankaj · Answer 6 · 2019-01-19T08:19:52.867

After Enabling Postgresql extension from WAMP icon i was able to get postgresql admin page but bin/cake bake all command was failing with error 'php extn missing'. (referred @rails_id's post below to complete postgresql integration with WAMP)
checked in cmd prompt with php -m, no "postgresql" module was present.
Went to php installation directory, in my case it was "C:\wamp64\bin\php\php7.2.10" and enabled (removed the ;) following pg module in php.ini file:

extension=pdo_pgsql extension=pgsql
restarted the wamp services.
bin/cake bake all is working fine from command prompt.

score 0 · Answer 7 · answered Jun 05 '20 at 15:28

Not sure why you are checking this page , but even after trying all the above and following other pages only for the reason that you have wamp already iinstalled .. then dont waste your time .

checkout below link https://bitnami.com/ which makes you wamp integration with postgreSQL damn easy ,without WAMP server :b ,

And now start your project right away !!

Integration of postgreSQL on WAMP

7 Answers7

Linked