How To Install phpPgAdmin on Ubuntu 14.10, 14.04 and 12.04

3 years ago
Posted by andri
Board Tutorial
565 views


phpPgAdmin is an web interface for accessing and managing PostgreSQL databases in a very easy way. We can easily create new databases, tables in database, users, stored procedures etc. Also we can execute PL/pgSQL and other stored procedures. It also provides option for database backup and restore from web interface.

This article will help you to install phpPgAdmin web interface to manage PostgreSQL server on Ubuntu Systems. We are assuming that you already have installed PostgreSQL in your Ubuntu system, If not first install it using another articleInstall PostgreSQL on Ubuntufirst.

Step 1: Install phpPgAdmin

We are assuming here that you already have PostgreSQL server running on your Ubuntu system. If not install it first. Now phpPgAdmin packages are also available under default Ubuntu repositories. Use following command to install phppgadmin.

 
$ sudo apt-get update
$ sudo apt-get install phppgadmin
 

Step 2: Access phpPgAdmin

Now phpPgAdmin is available to access from localhost only. To access from local system just type below url in your favorite browser.

 
http://localhost/phppgadmin

 

phpPgAdmin Login Screenstyle="border-width:0px; clear:both; display:block; font-size:inherit; height:auto; margin:0px auto; max-width:100%; outline:0px; padding:0px; vertical-align:middle; width:550px" />

Now if you want to access phpPgAdmin web interface from remote system like your local LAN or remote public network server. We need to make little changes in PostgreSQL Apache configuration file. To do it edit below file

 
$ sudo nano /etc/apache2/conf.d/phppgadmin
 

Now uncomment allow from all line in configuration file

 
order deny,allow
deny from all
allow from 127.0.0.0/255.0.0.0 ::1/128
allow from all
 

Save you file and restart apache service using following command.

 
$ sudo service apache2 reload 

Source :tecadmin.net