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

      OpenProject ID 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

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Database migration

Database migration

Added by kuma x almost 5 years ago

my current openproject is installed in a docker with centos 7, now i tried to migrate the postgre sql database to a DEB/RPM environment, did not work it out, and i tried to migrate the database to another docker, did not make it right, too, i follow exactly what the openproject instructions, can any body give me some help on the migration. thanks in advance.

Kuma


Replies (3)

RE: Database migration - Added by Oliver Günther almost 5 years ago

Hi Kuma,

could you elaborate on what went wrong? "Did not work" will not provide us any help on how to improve the migration path.

In general, you should be able to migrate with:

  1. Creating a database dump from your docker postgresql using our Docker backing-up guide
  2. Installing an OpenProject package. In the wizard, choose to select install for the postgres step. 
  3. This will install a PostgreSQL server with an OpenProject database on it.
  4. Afterwards, restore the dump with our packaged restoring guide

The only remaining thing is to restore attachments, which you can simply copy and paste to the location specified in the restoring guide as well.

Cheers

Oliver

RE: Database migration - Added by kuma x almost 5 years ago

Hi Oliver

I created a dump file openproject.sql from the docker postgresql.

and then followed the restoring guide to import the openproject.sql to another container, the logs you already seem.

I did tried to restoring the openproject.sql in a DEB/RPM PostgreSQL, it says not a valid dump file.

I have no idea what have I missed.

RE: Database migration - Added by kuma x almost 5 years ago

Hi Oliver

I created a dump file openproject.sql from the docker postgresql.

and then followed the restoring guide to import the openproject.sql to another container, the logs you already seem.

I did tried to restoring the openproject.sql in a DEB/RPM PostgreSQL, it says not a valid dump file.

I have no idea what have I missed.

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