在xampp中的Postgresql，phpPgAdmin

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.

Im using xampp ver 1.7.7 , Postgresql 9.2.4 64 bits , 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 \ php.ini, 
  then look for the line " ; extension = php_pgsql.dll "remove tag ';' it 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