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, 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/ file to false.

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