Forums » Help »
Migrating from MySQL to Postgres Database (and a different version of Redmine etc.)
Added by Daniel Poggenpohl over 8 years ago
Hi everyone,
I'm currently trying to migrate to a newer version of Redmine. I'm also migrating from a MySQL database setup to a Postgres database setup.
The details follow:
The "old" server:
OS: Solaris 10 10/09 i386
Ruby: 2.1.0
Rubygems: 1.8.25
Rails: 4.2.5
Database: local MySQL 14.14 Distrib 5.6.15
Redmine: 2.5.1
Redmine plugins: Redmine Tags 2.1.0
The new server:
OS: Solaris 11.3 x86 64Bit
Ruby: 2.3.1
Rails: 5.0.0
Database: remote Postgres 9.5 (Postgres driver 9.5)
Redmine: 3.3.0 (no plugins yet)
Gems: pg 0.18.4
How do I migrate the database from MySQL to Postgres?
And do I need specific things to do to migrate from the Redmine 2.5.1 database structure to the Redmine 3.3.0 structure?