Django - Using PostGIS database with PostgreSQL database, do I need 2 databases?

Question

I'm currently using a single PostgreSQL database, with standard settings.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'postgres',
        'USER': 'postgres',
        'PASSWORD': password,
        'HOST': 'localhost',
        'PORT': '',
    }
}

My question is, can I keep using the default postgres setup, and just perform CREATE EXTENSION postgis in the shell to get access to postgis features? Or do I need to add a postgis database separately, like below:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'postgres',
        'USER': 'postgres',
        'PASSWORD': password,
        'HOST': 'localhost',
        'PORT': '',
    }
    'geodata': {
         'ENGINE': 'django.contrib.gis.db.backends.postgis',
         'NAME': 'geodjango',
         'USER': 'geo',
    },
}

alfredo138923 · Accepted Answer · 2018-05-01 22:25:36Z

14

You can keep using the default postgres setup, just changing the engine to: django.contrib.gis.db.backends.postgis

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': 'postgres',
        'USER': 'postgres',
        'PASSWORD': password,
        'HOST': 'localhost',
        'PORT': '',
    }
}

answered May 1, 2018 at 22:25

alfredo138923

1,5691 gold badge15 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Valachio Over a year ago

Ah so I am guessing django.contrib.gis.db.backends.postgis is an extension that includes everything in django.db.backends.postgresql_psycopg2 plus geo-specific features?

alfredo138923 Over a year ago

You're right. django.contrib.gis.db.backends.postgis just extends django.db.backends.postgresql_psycopg2 to add the PostGiS types.

Collectives™ on Stack Overflow

Django - Using PostGIS database with PostgreSQL database, do I need 2 databases?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related