Top Menu

Jump to content
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    Home
    • 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

Collapse project menu

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

Content

Expand project menu
General discussion
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. General discussion
  5. openproject run backup with PostgreSQL database

openproject run backup with PostgreSQL database

Added by Pierre Roukens almost 7 years ago

Hello all,

I've installed OpenProject on Ubuntu 16.04 with the package option and a PostgreSQL database. Everything works fine except the "openproject run backup" script.

When executing the "openproject run backup" script it shows "Generating database backup.../opt/openproject/packaging/scripts/backup: line 34: mysqldump: command not found". 

So, since I'm not using a MySQL database, this error makes sense. But how can I fix this so the script will backup the PostgreSQL database?

Regards, Pierre Roukens


Replies (2)

RE: openproject run backup with PostgreSQL database - Added by Oliver Günther almost 7 years ago

Hi Pierre,

unfortunately, the backup script in < 8.0 versions did not provide backups for PostgreSQL. I fixed this for 8.0.0 (released today).

However you can simply backport the script from here

  1. Download file from https://raw.githubusercontent.com/opf/openproject/dev/packaging/scripts/backup
  2. Override packaging/scripts/backup

Best,

Oliver

RE: openproject run backup with PostgreSQL database - Added by Pierre Roukens almost 7 years ago

Hi Oliver,

Thanks for the quick reply! Clear, I will replace the script, thanks!

Regards, Pierre

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