How to troubleshoot Django errors when migrating sqlite database to postgres

Overcome integrity, duplicate keys, and contenttype errors when attempting a database migration from sqlite to postgres for a Django project. ## Troubleshooting To overcome this error django.db.utils.ProgrammingError: relation "blog_category" does not exist Uncomment line in forms.py so that categories are not fetched before the table is created To overcome this error django.db.utils.IntegrityError: Problem installing fixture Could not load contenttypes.ContentType Remove auto added contenttypes from django for loading data $ python3 manage.py shell from django.contrib.contenttypes.models import ContentType ContentType.objects.all().delete() If you run into this error: Key (id)=(1) already exists try commenting out pre-save methods (signals.py) Timestamps 5:00 - Table does not exist 9:12 - Key already exists 10:43 - Another Key already exists error