Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Integration of postgreSQL on WAMP

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)

like image 623
Ammar Hayder Khan Avatar asked Jan 31 '13 08:01

Ammar Hayder Khan


2 Answers

  1. 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.
  2. Download phpPgAdmin here.
  3. Extract phpPgAdmin-5.1.zip in C:\wamp\apps So the path will be, C:\wamp\apps\phpPgAdmin-5.1.
  4. 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>
    
  5. Left Click on the Wampserver Tray icon. Navigate to PHP > PHP extension. Then enable this

    a. php_pgsql 
    b. php_pdo_pgsql extension.
    
  6. 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

  7. Restart All service

  8. Go to http://localhost/phppgadmin/ and try to login.

  9. Default Login credentials are

    • Username = "postgres"
    • Password = "root"

references :

  1. WAMP + PostgreSQL integration
  2. sourceforgenet phpPgAdmin downloadable for Windows with Wamp
like image 143
rails_id Avatar answered Sep 19 '22 19:09

rails_id


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>
like image 36
Jessica Gramp Avatar answered Sep 17 '22 19:09

Jessica Gramp