HOWTO Fully Install PostgreSQL on Debian

This article was first written in March 2005 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/218).
This is a short tutorial on how to fully install PostgreSQL (with ready-to-use user accounts and test table) on a simple Debian installation. When not specified otherwise by the command line prefix or by a full statement, you are supposed to have root permissions.

The packages

To install the PostgreSQL base system as well as a textual client, you need to issue the following command
apt-get install postgresql postgresql-client
This will ins