How to migrate from sqlite to postgres

Question

I already have a django project live on heroku. I am now wanting to migrate the database from sqllite to postgres because of some issues regarding heroku like when I set DEBUG=True, the site runs without any issues but as soon as I set DEBUG to False, I get server error 500. I'd hard time finding any working solution, so I've decided to move to postgres. So, I have changed my settings.py file to have default db as postgres. I don't know about any other change in this file regarding the production settings.Also, I'm on windows machine and have installed postgres, also installed the psycopg2 library.I have created the db manually in postgres.

The issue I'm facing is, as soon as I run makemigrations command, it creates an sqlite db. Why does this happen?

Does this answer your question? [Django: What are the best practices to migrate a project from sqlite to PostgreSQL](https://stackoverflow.com/questions/3476606/django-what-are-the-best-practices-to-migrate-a-project-from-sqlite-to-postgres) — mattm, Jan 22 '20 at 19:07

score 0 · Answer 1 · answered Jan 04 '19 at 20:37

0

After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.

answered Jan 04 '19 at 20:37

augu1352

1

1

done that ofcourse, but it is creating a sqlite db instead of postgres – Dacey Jan 05 '19 at 08:14

How to migrate from sqlite to postgres

1 Answers1