Content
Restoring database backup breaks Openproject
Added by User Detzi over 5 years ago
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!