Django PostgreSQL


Make sure to have some packages installed:

sudo apt-get install libpq-dev
pip install psycopg2

Database settings for PostgreSQL:


    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'myprojectDB',
        'USER': 'myprojectuser',
        'PASSWORD': 'password',
        'HOST': '',
        'PORT': '5432',

In older versions you can also use the alias django.db.backends.postgresql_psycopg2.

When using Postresql you'll have access to some extra features:


ArrayField         # A field for storing lists of data. 
HStoreField        # A field for storing mappings of strings to strings. 
JSONField          # A field for storing JSON encoded data. 
IntegerRangeField  # Stores a range of integers 
BigIntegerRangeField # Stores a big range of integers 
FloatRangeField    # Stores a range of floating point values. 
DateTimeRangeField # Stores a range of timestamps