Configure PostgreSQL server

First install PostgreSQL server

apt-get install postgresql

To compile psycopg2 you will also need

apt-get install postgresql-server-dev-9.1

Configure database access for local user

sudo -u postgres createuser --createdb --createrole --no-superuser <same_as_local_username>

Connect to postgres database

psql postgres