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
    • 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
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Openproject 11 and Debian 10: Upgrade both to latest using a backup?

Added by Steffen K almost 3 years ago

I have a virtual machine running Debian 10 and Openproject 11 as a a package installation. It's a very small server with less than 10 users. Now I want to upgrade the OS to Debian 11 (that also includes Postgresql 13 by default) and Openproject to version 12.

So I'm thinking about doing an upgrade like this:

  • Do a backup using Openproject using the included backup tool.
  • Create a fresh virtual machine and do a clean install Debian 11.
  • Install Openproject 12 as stated in the manual.
  • Transfer the backup files from the old server to the new server using rsync or SFTP.
  • Do a restore of this data on the new virtual machine.
  • Trash the old virtual machine.

I'm I missing something? Or will this work flawlessly?


Replies (4)

RE: Openproject 11 and Debian 10: Upgrade both to latest using a backup? - Added by Piotr F almost 3 years ago

Is your original db in postgresql 13?

Because in the manual there is a step to migrate db itself from 10 to 13.

Migrating your OpenProject installation to PostgreSQL 13

RE: Openproject 11 and Debian 10: Upgrade both to latest using a backup? - Added by Steffen K almost 3 years ago

No. The current server is running postgresql 10 installed from from postgresql's own repositry.

Do versions matter in case of postgresql when you do a dump of the database in e.g. version 10 and restore the dump on another server that is running version 13 for example?

RE: Openproject 11 and Debian 10: Upgrade both to latest using a backup? - Added by Piotr F almost 3 years ago

Steffen, no idea, but logically, if there is requirement to upgrade db separately, I would say you should have done this.

Not sure though.

RE: Openproject 11 and Debian 10: Upgrade both to latest using a backup? - Added by Steffen K almost 3 years ago

Just did it on the same VM. My Postgresql was installed from Postgresql's own repositries.

  1. Stopped the Webserver
  2. Installed the latest Postgresql 14
  3. Moved the database from the earlier installed Postgresql 10 to the newly installed Postgresql 14
  4. openproject configure
  5. Started the webserver again to see if everything was still working
  6. Stopped the webserver again
  7. Edited Openproject's sources.list so that it points to version 12
  8. Upgraded Openproject using apt-get
  9. openproject configure
  10. Started the webserver again to see if everything was still working
  11. Stopped the webserver again
  12. Edited all three sources.list files (Openproject, Postgresql and Debian) so that they point to bullseye
  13. "dist-upgrade" and reboot

And after the reboot everything was working fine. Although I just ran openproject configure once more just to check if this shows any problems.

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