I recently decided that I want to switch from MySQL to Postgres due to several problems that I had that should never be a problem for Postgres.
However, I cannot find a good way to migrate. I looked at py-mysql2pgsql, but it caused database problems that I cannot track.
I also studied dumpdata and loaddata using django-admin.py, however my database is quite large and it consumed all my memory and just crashed, so I switched to django-dumpdata-chunks that just log out and then again projec is two years old.
What am I asking if anyone knows of a good reliable way to switch from mysql to postgres without breaking the database and as a bonus, if possible, without downtime?
source share