We had a power outage on our openproject server and after we powered it on there is only one project that shows online but I see other projects in the postgres sql. How can I recover from this.

openproject=# select name from Projects;
name
———————————————————-
August BCP Test
Network Capture Evaluation
Monitoring Cleanup
VMware Migration
Connections Kill Switch

Thanks,

Vinod N

Hello Vinod,

OpenProject just uses the database as data source so the problem must be related to this and not to OpenProject itself.

- Check the ‘config/database.yml’ if you use the correct database

- Check if you run OpenProject in the correct environment (may be you run OpenProject in development mode and development database is used)
- Are you logged out and you only have one public project

Open a rails console and check the Projects there:

From OpenProject root folder

RAILS_ENV=production bundle exec rails c

In the Rails console

Project.all

Best
Ratzi

Thanks the database.yml had two production entries for some reason, corrected it and it works fine now. I was a bit worried there.
Is there a backup procedure that I can follow to fall back in case of data corruption

Thanks

Hello again,

in case of data corruption you should use the latest database backup ;)

Best
Ratzi

Is all the data driven through postgressql, I guess I was looking for all the important files and tables so I can schedule a backup