Posted by

How to install phpPgAdmin

phpPgAdmin is a database administration tool dedicated for PostgreSQL, much like phpmyadmin for mySQL. It’s a great tool which will help you manage your database without installing other client app in your system.

This tutorial was applicable only to those who already have installed postgre on the server.

First is download the phppgadmin files

You can download it by cloning it in their repository

cd /path/to/your/www
git clone git://github.com/phppgadmin/phppgadmin.git pgadmin

Manual download is also available here http://phppgadmin.sourceforge.net/doku.php?id=download. Upload and extract it in your server.

Nex is to update the configuration

Copy the file config.inc.php-dist to config.inc.php from this directory /path/to/your/www/pgadmin/conf/

Open the config.inc.php you just copied, find and update this line of code

$conf['servers'][0]['host'] = '';

to

$conf['servers'][0]['host'] = 'localhost';

For instance that you have a different port then replace the default port 5432 to the one you have.

Now you can access and manage your database using it.

http://to_your_server/pgadmin