Postgresql, phpPgAdmin in xammp

Question

Hi I have this error while I'm trying to launch phpPgAdmin:

Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.

I'm using XAMPP ver 1.7.7, Postgresql 9.2.4 64 bit, and phpPgAdmin 5.1.

I already did the following:

1. Open config.inc.php found in C:\xampp\phpPgAdmin\conf\ and set extra_login_security to false

$conf['extra_login_security'] = false;

2. Find php.ini file in C:\xampp\php\, then look for the line ; extension = php_pgsql.dll. Remove tag ;, so that the result was extension = php_pgsql.dll.

(although I found php.ini- production and development so I uncomment them both)

3. Open C:\xampp\apache\conf\extra\httpd-xampp.conf and in section <IfModule mime_module> add

Alias /phppgadmin "c:/xampp/phpPgAdmin/"
<Directory "c:/xampp/phpPgAdmin">
    AllowOverride AuthConfig
    Order allow,deny
    Allow from all
</Directory>

4. LoadFile “C:/xammp/php/libpq.dll”

but I still get this error. Can someone help me?

Answer 1

I am writing the answer from the beginning, not everything what you tried was wrong.

xampp is up and running.

Download phpPgAdmin and copy it into c:\xampp\phpPgAdmin

Modify the config file

C:\xampp\apache\conf\extra\httpd-xampp.conf

Add like phpMyAdmin part the phpPgAdmin part:

Alias /phppgadmin "C:/xampp/phpPgAdmin/"
<Directory "C:/xampp/phpPgAdmin">
    AllowOverride AuthConfig
    Require all granted
</Directory>

Restart apache and enter in browser

http://127.0.0.1/phppgadmin/

Now you would get the message: install php with –-pqsql option

Postgres installation and the configuration:

Install postgresql 32bit even if you have 64bit windows (this is not a joke)

Postgres is now up and running

Modify again the config file

C:\xampp\apache\conf\extra\httpd-xampp.conf

Add the following line (in my case PostgreSQL is installed in C:/xampp/PostgreSQL):

LoadFile "C:/xampp/PostgreSQL/bin/libpq.dll"

before the following existing lines

LoadFile "C:/xampp/php/php5ts.dll"
LoadModule php5_module "C:/xampp/php/php5apache2_4.dll"

Modify the config file

C:\xampp\php\php.ini

Uncomment the following line by removing ';'

;extension=php_pgsql.dll

Restart apache and enter again in your browser

http://127.0.0.1/phppgadmin/

It should work, it works for me