Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Migrate from Packaged to Docker

Migrate from Packaged to Docker

Added by Rob A over 2 years ago

Hi everyone,

I've been running Openproject for several years now based on a packaged install from version 8 or 9.  Aside from a few small issues it's been smooth sailing upgrading all the way to the current version.

EDIT:  This is an old database that was migrated from MySQL

I have most of my other self-hosted infrastructure running in a 3-node docker swarm now and I wanted to move Openproject to this cluster.

My steps were:

  1. Stop current instance of Openproject
  2. Run a full backup using the backup tool
  3. pg_restore the database into the PG container
  4. Copy attachments into correct docker volume.
  5. Start the stack.

Initially there were some LDAP errors but once I recreated my LDAP config and restarted the containers those went away.

No other errors are present on any of the containers.

The problem is that now all projects created after 2019 are missing.  I'm assuming it has something to do with some database changes that occurred during one of the many updates over the years.

Is there a way to migrate to docker from a packaged installation?

Is there a way to fix my database so it imports correctly?

Thanks,

Rob


Replies (3)

RE: Migrate from Packaged to Docker - Added by Adam Szabo over 2 years ago

Hi Rob

please share

1. Current instance of OpenProject

Make a screenshot where a project with Work packages exist which are generated after 2019, please also share your version of OpenProject Packaged

2. Run a full backup using the backup tool

Please log the terminal and share ALL your terminal output

3. pg_restore the database into the PG container

Please log the terminal and share ALL your terminal output

Assuming the steps 4 and 5 you did during your upgrades and assuming you are on version 12.2.5 with your packaged, correct, then please show a screenshot like request in Point 1.

4. Did you migrate the database from MYSQL to PSQL 10? When? Did it work afterwards? This was maybe done in an Upgrade or manually? do you have terminal logs from that time?

5. Did you migrate the database from PSQL 10 to PSQL 13? When? Did it work afterwards? This was maybe done in an Upgrade or manually? do you have terminal logs from that time?

You see it is a little bit too complex for just sharing plain text, terminal logs are necessary here.

Thank you for following up, when you collected all your output

RE: Migrate from Packaged to Docker - Added by Rob A over 2 years ago

Adam,

I'm really confused, but everything worked the second time.

My steps were:

  1. Stop current instance of Openproject
  2. Run a full backup using the backup tool
  3. Remove and recreated the database in the PG container.
  4. pg_restore the database into the PG container
  5. Copy attachments into correct docker volume.
  6. Start the stack.

The pg_dump file was about twice the size this time and it restored all of my data into the postgres container.

Thanks for your help.

Rob

RE: Migrate from Packaged to Docker - Added by Adam Szabo over 2 years ago

Hi Rob,

I am happy to hear it was one of those unknown errors that we cannot investigate anymore in 2022 :) - ghost in the machine

thank you for your feedback

  • (1 - 3/3)
Loading...