Open link in a new tab

Content

Expand project menu

Restoring database backup breaks Openproject

Good Day,

i started evaluating Openproject on a freshly installed ubuntu server 18.04. I installed Openproject and succesfully managed to enable SSL, create a Test - User, Project and  Repository. I then backed up Openproject with this  command from the Openproject Website

sudo openproject run backup

it genereates all the expected output including the pgresql-dump.

I then setup a second server and repeated the same process as before but now tried to restore my created backup.

sudo apt-get install openproject -y
sudo openproject configure

After the configurationfinishes in which i create a new pgresql database i get the Database URL with

sudo openproject config:get DATABASE_URL

and then restore my backup from the other Server with

pg_restore -h 127.0.0.1 -U openproject -W openproject postgresql-dump-20190719180006.pgdump

this seems to execute with no error. After that i ran:

sudo openproject reconfigure

But no matter what i do i end up with the server unresponsive only telling me "Service temporarilly not available"

I  also tried to set the database URL manually but with no success:

sudo openproject config:set DATABASE_URL="postgres://openproject:HJJqHuzsvPLLL4bpYpXfOtbQ0xfigcvn@127.0.0.1:45432/openproject"

Does someone have an idea how i can restore my Backups?

Thanks in advance!