Added by Vinod Narayanan about 10 years ago
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
Replies (4)
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
In the Rails console
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