phpPgAdmin is a web based GUI for administrating a PostgreSQL database server.
How to get it installed easily on Ubuntu 7.10…
In terminal type :
$ sudo apt-get install phppgadmin
This will set up and install all of the phpPgAdmin packages. It will also set-up and configure Apache and php5 for you too if you haven’t installed these already.
Next, create a symlink to phpPgAdmin so that Apache can find it:
$ sudo ln -s /etc/phppgadmin/apache.conf /etc/apache2/conf.d/phppgadmin.conf
Now if you navigate to http://localhost/phppgadmin you should be greeted with the phpPgAdmin screen.
If you can able to use the phpPgAdmin interface as the default ‘postgres’ administration account, you will need to do the following
$ sudo gedit /usr/share/phppgadmin/conf/config.inc.php
find and change the following line
$conf['extra_login_security'] = true;
$conf['extra_login_security'] = false;
Save and close gedit.
$ sudo /etc/init.d/apache2 reload
Type http://localhost/phppgadmin in your browser and shall ready for you.