PosgreSQL database lost. Does this mean all my confluence pages are gone?

[Boris Alexandrov]

I lost the PostgresSQL server and its backup .Is there a way to recover Confluence pages from the filesystem?

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Boris Alexandrov]

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.

[Nic Brough -Adaptavist-]

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

[Boris Alexandrov]

Thanks.  I have recovered my bitbucket by creating a new instance and copying the repositories over. Appreciate your help.