Upgrading redmine version and changing db from mysql to postgresql

Added by Pawel Jasinski about 1 year ago

hi,

I have the following system:

Redmine version                3.3.2.stable.16388
Ruby version 2.2.6-p396 (2016-11-15) [x86_64-linux]
Rails version 4.2.7.1
Environment production
Database adapter Mysql2
plugins: agile:1.4.2, checklists:3.1.5, issues_tree:0.0.11, tagging:0.1.5

and would like migrate to a new system with:

latest stable version of redmine (3.4.x) 
postgresql instead of mysql

There is number of instructions about upgrading a version of redmine, but I haven't found anything about the redmine mysql->postgres change.
Is it realistic to change anything in one step?
Or perhaps split migration into 2 steps, first redmine version, followed by db change?

Assuming I do 2 step migration, how should I go about the db migration?
I have seen plenty of generic tools to move from mysql to postgres. Will it work with redmine?

Cheers,
--pawel

Replies (2)

RE: Upgrading redmine version and changing db from mysql to postgresql - Added by Pawel Jasinski about 1 year ago

I did 2 step migration.
The generic instruction for moving from a server to a new server (container) worked.
The db migration was done with pgloader.

RE: Upgrading redmine version and changing db from mysql to postgresql - Added by Christopher Caruk 4 months ago

Hi Pawel,

Could you share your pgloader load file or command line options?

Thanks
Chris

(1-2/2)