How can I migrate my Redmine deployment from MySQL 5 to PostgeSQL 8.2?

Question

I have full access to both databases, but clearly a MySQL dump file isn't going to import cleanly into Postgres. Are there any good step-by-steps for migrating from MySQL to Postgres?

Answer 1

There are a few MySQL -> PostgreSQL migration resources linked from the PostgreSQL wiki. I've never tried migration with Redmine though.

PostgreSQL 8.2 is quite old now, is it provided by a hosting provider, or can you use a more recent version?

Answer 2

I've used SQL::Translator to do mysql to postgres conversions in the past. Worked pretty well for me.