You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
had an abnormal shutdown and after recovery Confluence would not start due to version mismatch between the postgres database confluence. I read the docs on that and it clearly stated that if this problem occurs and there was no recent upgrade then remove the CONFVERSION table. https://confluence.atlassian.com/confkb/confluence-will-not-start-up-because-the-build-number-in-the-home-directory-doesn-t-match-the-build-number-in-the-database-after-upgrade-376834096.html
Once I did that its start up fine, however the data is two years old. Not only that, but Jira data that resides on that postgres server is also old. Tech support told me to create a new database and restore from backup. My issues, other than not having any experience at postgres databases, is if i cant trust the database, how can i trust that the backups are good? Seems to me that the reboot caused postgres to load and provide the wrong database. I would like to figure out how to load the correct database.. looking for some guidance from you Atlassian Gurus. Much thanks for your consideration and expertise.
Welcome to the Atlassian Community!
There's no way we can tell you whether the backups you have taken and restored are any good. You need to talk to the people who took the backups.
The one bit we can tell you though is that if the system is running, the restored data is at least in the right shape, which implies that the backup was complete.