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. Backup and Restore

Backup and Restore

Added by Jochen Winkler over 4 years ago

I hope someone can help me I am currently at a loss. I read both articles backup and restore openproject (DEB/RPM intstallation). 

I`m running it on a ubuntu 20.04 lts system and want to change the server. Operating System keeps the same, hardware is changed. On the old system i made the backups and copied (changed the access authorization) the files (attachements, conf, postgresqul-dump, svn) via filezilla on another pc. 

Then i copied those files into the standard destination of the new server /var/db/openproject/backup. Then i restored the assets as described (with the correct name of the files), this worked fine i think. My problem is now that i don`t understand the description of the part restoring the database. 

I entered "sudo openproject config:get DATABASE_URL on the new server and got this information (password changed into xxxxxxx)

postgres://openproject:xxxxxxxxxxxxxxxxxxxx@127.0.0.1:45432/openproject

the next step is where i have my problem. What information do i have to insert in the following command and where???: 

sudo pg_restore --clean --if-exists --dbname $(sudo openproject config:get DATABASE_URL) postgresql-dump-20200804094017.pgdump

Could someone give me an example?

Thanks a lot and have a nice weekend 

Best regards Jochen


Loading...