Installing Postgres SQL

# adduser postgres --home /var/lib/postgresql

# passwd postgres

# apt-get install postgres-8.4

Install all dependencies.

Login as postgres or as root su - postgres

# psql postgres

Welcome to psql 7.4.17, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=#

postgres=# CREATE USER tracadmin WITH PASSWORD 'my_great_password';
CREATE USER

postgres=# CREATE DATABASE tracdb OWNER = tracadmin;
CREATE DATABASE

postgres=# \q

# logout