How to switch to postgresql?

Question

Django

Good day everyone.
I can not find a sensible description of how to switch from a MySQL database to PostgreSQL.
Modules like py-mysql2pgsql do not work correctly.
What other ways are there?
thank you in advance.

Answer 1

Option number 1 . Stock and not always working:
./manage.py dumpdata > db.json
Change the database to pg
./manage.py migrate
./manage.py loaddata db.json
Option #2 . You need to install django-extensions:
./manage.py dumpscript appname > scripts/appname_db.py
Change base to pg
./manage.py migrate
./manage.py runscript appname_db.py

Answer 2

pgloader.io - for data migration
Well, if there are complex queries, they may not take off without a file.