Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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?

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.