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. Correct command order for Docker restore .pgdump and attachments

Correct command order for Docker restore .pgdump and attachments

Added by Marc Walter over 3 years ago

Hi

I set up a docker host system with portainer. This works so far fine and has nothing to do with Openproject, I know.

I had a openproject community version installation (probably it was Openproject 11). Since a year it was not running. I would like to restore that openproject installation now in a docker container. It's not a critical enviroment. The Openproject 11 installation was on a centos system and I had a little bit trouble to get it working with reverse proxy and everyhing because I had on the same machine a mediawiki running.

I was able to save the data with the backup command.

  • attachments-20220122144341.tar.gz
  • conf-20220122144341.tar.gz
  • postgresql-dump-20220122144341.pgdump

So far it looks good to me. I can also start a new container with openproject on my new docker host and I can access this new installation. Now i want to restore the old installation.

I tried this: https://www.openproject.org/docs/installation-and-operations/operation/restoring/#docker-based-installation

But i was not lucky. Can someone help me with the correct order of the steps.
Of course there are some musts:

The database need to be stored external so not in the container also the attachments and the config. I don't want to lose the data. I'm not sure about the config what do to with it?

I also already transferred the backup of my old openproject installation to the docker host so I have those files there. The folders are also created for:

/var/lib/openproject/pgdata

/var/lib/openproject/assets

I'm also not sure about this:
ATTACHMENTS_STORAGE_PATH /var/openproject/assets/files <- Do i need to unzip here the attachments?

So a lot of questions and the documentation is good but also a little bit vague...

Thanks for your help


Loading...