Home / server / Questions / 105870
In Process
Chris R
Asked: 2010-01-25 10:28:28 +0800 CST

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

  • 772

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?

migration mysql postgresql redmine

2 Answers

  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?

    • 1

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

    • 0