migrate-django-sqlite-postgresql.md

Migrate Django Database from SQLite to PostgreSQL

Backup all data in SQLITE

./manage.py dumpdata --exclude=contenttypes --natural-foreign --natural-primary > datadump.json 

---

Reconfigure Database settings

Change database setting to postgresql configurations replacing values correctly

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': '<DATABASE_NAME>',
        'USER': '<DATABASE_USER>',
        'PASSWORD': '<DATABASE_USER_PASSWORD>',
        'HOST': '<DATABASE_HOST>',
        'PORT': <DATABASE_PORT>,
    }
}

---

Migrate All Django Application models

./manage.py makemigrations

./manage.py migrate

---

Restore all data to PostgreSQL

./manage.py loaddata datadump.json