[Fixed]-Django project Migration from SQL lite to postgres – relation "django_content_type" does not exist

by

0👍

✅

So after playing around it started to work.
Solution was that I havent added the server to pgAdmin https://www.pgadmin.org/

I was under assumptions that pgadmin is just a tool to see whats going on but without adding postgre to pgadmin the migration had errors.

👤Ilya Bibik

1👍

Your DATABASES section in settings.py should be like:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'yourdb',
        'USER': 'youruser',
        'PASSWORD': 'yourpass',
        'HOST': '',
    },
}

Your INSTALLED_APPS should include psycopg2
Once this in place and server restarted, you can remigrate, which should create the missing table

👤dmitryro

0👍

django_content_type should be created automatically.
I’m wondering how did you do your makemigrations
Maybe try

python manage.py makemigrations

instead of doing them one by one

👤I. Xue

Leave a comment