Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.