Open link in a new tab

Content

Expand project menu

openproject run backup with PostgreSQL database

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

Message actions

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

Message actions

Hi Oliver,

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

Regards, Pierre