5

I recently decided that I want to switch from MySQL to Postgres because of a few problems I have been having which should never be a problem on Postgres.

However I cannot seem to find a nice way to migrate I have taken a look at py-mysql2pgsql however this caused issues within the database which I cannot track down.

I also looked into dumpdata and loaddata using django-admin.py however my database is rather large and it consumed all my memory and simply crashed so I then moved onto django-dumpdata-chunks which just errors out but then again the projec is two years old.

What I am asking is does anyone here know of a good reliable way to migrate from mysql to postgres without breaking the database and as a bonus if possible without downtime?

Improve this question

1 Answer 1

Reset to default
3

Check out pgloader. It should make your life a lot easier.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

This looks like the ticket for me, ill do a little more digging but big thank you for this!

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.