2007 Mar 26 - Mon

Installation and Configuration of PGAdmin on Debian

A multiplatform GUI tool called pgAdmin is available for managing and querying PostgreSQL databases. It is available at www.pgadmin.org.

For Windows platforms, an executable installation program is available.

For Debian platforms, don't install the package from the Debian web site. Instead, through a little config file magic, a Debian package direct from pgAdmin can be installed.

First, you'll need to determine your nearest mirror. Choose a mirror, and past it in the following format into /etc/apt/sources.list:

deb [MIRROR URL]/pgadmin3/release/debian testing pgadmin

You should then be able to run the following commands to get it installed:

apt-get update
apt-get install pgadmin3 

You can start pgadmin through the command pgadmin3. In order to manage the database, you'll have to login first as postgres, or try this simple expedient (warning this is not very secure for your database). Place the following line into /etc/postgresql/7.4/main/pg_hba.conf:

host    all         postgres    127.0.0.1         255.255.255.255   trust

In pgadmin, you'll need to connect to the database. You can connect to a specific database through existing credentials, or if you are looking to create new databases, you should connect via the above credentials and connect to template1.