phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP. It is a very nifty tool with a very convenient GUI interface. If you have used phpMyAdmin for MySQL, this phpMyAdmin for PostgreSQL.

To install phpPgAdmin on Ubuntu 10.x, to the following:
1. sudo apt-get install phppgadmin
2. open your browser and type http://localhost/phppgadmin
3. Login and start using phpPgAdmin

If you see the error: Login disallowed for security reasons, do the following:
1. Configure your pg_hba.conf to configure client authentication. See postgre wiki
2. If this doesn't work, set extra_login_security in /etc/phppgadmin/config.inc.php file to false.

If you have other installation problems, refer to Installation FAQ

Note: be sure to backup the config files before you edit them