I lost the PostgresSQL server and its backup .Is there a way to recover Confluence pages from the filesystem?
Yes.
If you lose the database, you lose your data.
If you have not turned off the automatic backups, then you should find some .xml files in <confluence-home>/export - one of them can be used to restore your data. But if that's off and you've lost your database and backups of it, I'm afraid there's nothing left.
Thank you very much for your prompt response. It feels great not be alone in a situation like this.
Luckily as you pointed out I had not turned off the automatic backups. So I found them in backups folder of the confluence application-data folder and saved them. Then I have reinstalled confluence and imported the data.
As of now I am keeping those, and having the following strategy:
1. tar application-data/confluence directory
2. tar confluence installation directory
3. pg_dump the confluence data base to a local file.
4. copy and keep all those offsite
I will be testing the recovery strategy now.
Thanks again an please let me know if there is the same for Bitbucket ? I have not found any import option, but I see repositories and an export.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bitbucket is a bit different - the data exported from it is metadata about the use of Bitbucket - if you lose a Bitbucket database, yes, you lose that data, but the git repositories with your code are not part of Bitbucket, they're something BB looks after.
But, that said, the metadata is still important. I'd look to https://confluence.atlassian.com/bitbucketserver/data-recovery-and-backups-776640050.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks. I have recovered my bitbucket by creating a new instance and copying the repositories over. Appreciate your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.