We have already discussed about install postgreSQL on previous post, this post describe to configure postgreSQL and phpPgAdmin on XAMPP.

1. Install XAMPP latest version 

2. Install PostgreSQL (CentOS, Fedora)

3. Install phpPgAdmin,

We can install the phpPgAdmin in two ways, one is download and extract that package and another one is download using Git.
 

# yum install apr-*

Download the phpPgAdmin-5.1.tar.gz package using wget command and extract that tar.gz file.
 
# wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.1.tar.gz

# tar -xf phpPgAdmin-5.1.tar.gz

Move the directory to specific path /opt/lampp,
 
# mv phpPgAdmin-5.1 /opt/lampp/.

Another option is download package using Git.
 
# cd /opt/lampp

# git clone git://github.com/phppgadmin/phppgadmin.git


Cloning into 'phppgadmin'...

remote: Counting objects: 16946, done.

remote: Compressing objects: 100% (8/8), done.

remote: Total 16946 (delta 4), reused 0 (delta 0), pack-reused 16938

Receiving objects: 100% (16946/16946), 15.22 MiB | 145.00 KiB/s, done.

Resolving deltas: 100% (9114/9114), done.

Checking connectivity... done.


Once you have installed and configured it, both database and database management tool run on Xampp (MySQL, phpMyAdmin and postgreSQL,phpPgAdmin).

Configure with Apache : 

open the httpd-xampp.conf file 
 
# vim /opt/lampp/etc/conf/httpd-xampp.conf

Append below lines into it,
 
Alias /phppgmyadmin "/opt/lampp/phpPgAdmin"

<Directory "/opt/lampp/phpPgAdmin">
    AllowOverride AuthConfig Limit
   Require all granted
</Directory>

Finally, restart the Xampp all services,
 
# /opt/lampp/lampp restart

Open your borwser and check it.

http://localhost/phpPgAdmin