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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Good Backup practices around Database (Postgres)

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 Community Leader Nov 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
Community showcase
Published in Bamboo

Bamboo 7.1 is here and is packed with value!

I'm happy to announce that Bamboo 7.1 has been released and it’s overflowing with awesome new features. Top-voted issues First and foremost, a bunch of JAC top voted issues has been delivered - y...

980 views 4 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you