pgAdmin is the best GUI you can use to administrate PostgreSQL, unffortunately the Ubuntu default packages still offer only PostgreSQL 8.4 and an older version of pgAdmin III that does not support PostgreSQL 9.0.x. Thanks to Martin Pitt who maintains the latest packages you can run and maintain the latest PostgreSQL versions.
If you run Maverick:
- sudo apt-get remove pgadmin3 (if any old versions, make sure you dont create trouble with existing PostgreSQL 8.x versions)
- sudo vi /etc/apt/sources.list
add
deb http://ppa.launchpad.net/pitti/postgresql/ubuntu maverick main
deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu maverick main
- sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 8683D8A2
- sudo apt-get update
- sudo apt-get install pgadmin3
Check here for latest or other releases of Ubuntu.