Django: What are the best practices to migrate a project from sqlite to PostgreSQL

by

In my experience, dumping & restoring from SQL doesn’t work properly.

You should follow this sequence instead:

1. Dump db contents to json

$ ./manage.py dumpdata > dump.json

2. Switch the backend in settings.py

DATABASES = {
    # COMMENT OUT:
    # 'default': dj_database_url.config(default="sqlite:////full/path/to/your/database/file.sqlite"),
    # ADD THIS INSTEAD:
    'default': dj_database_url.config(default="postgres://localhost:5432/postgres_db_name"),
}

3. Syncdb and migrate the new DB to the same table structure

$ ./manage.py syncdb
$ ./manage.py migrate

4. Load the json to the new db.

$ ./manage.py loaddata dump.json

5. Congrats! Now the new data is in your postgres db.

More Related Contents:

  1. Different db for testing in Django?
  2. Prevent Django SQLite db from being overwritten while pushing to Heroku
  3. IntegrityError duplicate key value violates unique constraint – django/postgres
  4. Django bulk_create with ignore rows that cause IntegrityError?
  5. How to install libpq-fe.h?
  6. ImportError: No module named ‘_sqlite3’ in python3.3
  7. How to reset the sequence for IDs on PostgreSQL tables
  8. Django: permission denied when trying to access database after restore (migration)
  9. Migrating existing auth.User data to new Django 1.5 custom user model?
  10. Heroku: Django database file lost on every dyno restart
  11. Django and postgresql schemas
  12. Docker-compose with django could not translate host name “db” to address: Name or service not known
  13. Hi I am new to Django Framework.getting error :No Module Named
  14. How to upload a file in Django? [closed]
  15. How do I do an OR filter in a Django query?
  16. Django rest framework, use different serializers in the same ModelViewSet
  17. Setting the selected value on a Django forms.ChoiceField
  18. Load a Django template tag library for all views by default
  19. Output Django queryset as JSON
  20. Django: How can I call a view function from template?
  21. How to Unit test with different settings in Django?
  22. django – why is the request.POST object immutable?
  23. Heroku – Handling static files in Django app
  24. django – get() returned more than one topic
  25. Django, request.user is always Anonymous User
  26. Django migration error :you cannot alter to or from M2M fields, or add or remove through= on M2M fields
  27. django filter older than day(s)?
  28. django @login_required decorator for a superuser
  29. Django REST Framework image upload
  30. Django: dynamic database file

Leave a Comment