phpPgAdmin is a web based PostgreSQL software management package. To use it you should install and configure PHP, Apache and postgresql, see PostgreSQL for instructions.

Installing From Package

Install phpPgAdmin from the Universe repository see InstallingSoftware for detailed instructions on using repositories and package managers. (Note, however, that installation from a package manager often does not work).

From console:

sudo apt-get install phppgadmin

For Ubuntu 14.10 edit /etc/apache2/apache2.conf and add the following line to it:

Include /etc/apache2/conf.d/phppgadmin

For older Ububtu releases only: to set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf.

Include /etc/phppgadmin/apache.conf


Once phpPgAdmin is installed point your browser to http://localhost/phppgadmin to start using it. You should be able to login using any users you've setup in PostgreSQL.

Remote access

By default you can only access phppgadmin from localhost. If you want to be able to use it remotely, do the following:

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

or for older Ubuntu releases

sudo nano /etc/phppgadmin/apache.conf

Comment out (add # at beginning of line) "allow from ::1/128" and remove # from the line below it, "allow from all".

Then restart apache

sudo service apache2 reload

Note: This guide has been tested on Ubuntu 10.04 (Lucid).

Note: This guide has been tested on Ubuntu 12.10 (Quantal).


phpPgAdmin (last edited 2014-12-10 14:35:52 by ahmad-mushtaq)