Using PostgreSQL with Django

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’: ‘904ojioe_=3D’,
   ‘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