Just a reminder: this is how to create a Postgresql user and database:

postgres@exs:/root$ sudo su -c psql - postgres 
psql (9.1.4)
Type "help" for help.

postgres=# CREATE USER dontpanic WITH PASSWORD 'PASSWORD';
CREATE ROLE
postgres=# CREATE DATABASE dontpanic;
CREATE DATABASE
postgres=# GRANT ALL PRIVILEGES ON DATABASE dontpanic TO dontpanic;
GRANT
postgres=# \q