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:
- sudo apt-get install phppgadmin
- open your browser and type http://localhost/phppgadmin
- 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.
Note: be sure to backup the config files before you edit them