Here is how go set up Django to work with PostgreSQL

1. Install necessary libraries, etc
   1. sudo apt-get install libpq-dev
   2. sudo apt-get install python-dev
   3. sudo apt-get install postgresql-contrib
2. Create a new database and user
   1. sudo su – postgres
   2. createdb djangodev
   3. createuser -P djangodev
      1. Enter password, twice
   4. psql
      1. postgres=#  GRANT ALL PRIVILEGES ON DATABASE djangodev TO djangodev;
      2. \q
3. Make sure you have your virtual environment activated
4. pip install psycopg2
5. Open up the project’s settings.py and change the DATABASES to:
   DATABASES = {
       ‘default’: {
         ‘ENGINE’: ‘django.db.backends.postgresql_psycopg2’, # Add ‘postgresql_psycopg2’, ‘mysql’, ‘sqlite3’ or ‘oracle’.
         ‘NAME’: ‘djangodev’, # Or path to database file if using sqlite3.
         ‘USER’: ‘djangodev’,
         ‘PASSWORD’: ‘… PASSWORD …’,
         ‘HOST’: ‘localhost’, # Empty for localhost through domain sockets or ‘127.0.0.1’ for localhost through TCP.
         ‘PORT’: ”, # Set to empty string for default.
       }
   }
6. python manage.py syncdb