Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Boris Alexandrov May 5, 2020

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

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 5, 2020

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 May 6, 2020

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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 6, 2020

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 May 7, 2020

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events