Upgrading redmine version and changing db from mysql to postgresql
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 126.96.36.199
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?
RE: Upgrading redmine version and changing db from mysql to postgresql - Added by Pawel Jasinski over 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 about 1 year ago
Could you share your pgloader load file or command line options?