Open link in a new tab

Content

Expand project menu

Backup and Restore

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