Postgresql Setup
Postgresql Setup

* install psycopg2
* pip install psycopg2

Create role, database

    $ sudo -u postgres psql
    postgres# CREATE ROLE dd3 WITH LOGIN CREATEDB PASSSWORD 'dd3';
    CREATE ROLE
    postgres# CREATE DATABASE dd3;
    CREATE DATABASE

Login as dd3

    $ psql -U dd3 -h localhost -W
    password for user dd3:
    psql (9.3.10)
    dd3=>

za/dd3,za/dd3