Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Good Backup practices around Database (Postgres)

Subhi Andrews November 18, 2020

Hi,

We are running Bamboo and Postgres on the same Linux server. We are taking snapshots of the whole machine multiple times a day as backups (and possibly restore in case of a failure) Is this a sufficiently good practice? Should we worry that the snapshot will happen in the middle of a DB write and therefore will leave the DB in an inconsistent state?

Should we also do an export from Bamboo periodically? The only expected downtime for Bamboo is early hours on Sunday (so maybe not frequent enough).

Please advise,

 

1 answer

0 votes
Daniel Ebers
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.
November 18, 2020

Hi Subhi,

from my own experience the PostgreSQL backups are done best using stock backup techniques of PostgreSQL. This way the database is agnostic to what it is serving (PostgreSQL just 'don't care' if there is a Bamboo, a Jira or something else stored in it).
For this, you can simply refer to PostgreSQL documentation - nothing special.

With snapshot it depends - they have to produce a consistent output, yes - best is to do several test restores on a non-production environment to check if they are done correctly.

Last but not least you can do backups from Bamboo within (via Application). For that kind of approach I will link the documentation on this for you:
https://confluence.atlassian.com/bamboo/data-and-backups-289277245.html

Cheers,
Daniel

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events