||<>|| = Introduction = 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 }}} = Access = 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 127.0.0.0/255.0.0.0 ::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). '''Note:''' This guide has been tested on Ubuntu 15.10 (Wily). ---- CategorySoftware