Content
Backup and Restore
Added by Jochen Winkler over 3 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