You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
I am using the DIY bitbucket backup script for backups. My shared directory is on an NFS partition and the database is local.
When I run the backup script the rsync completes however I get an error that the system is unable to lock the database. I am running Bitbucket version 5.4.6.
I am using PostgreSQL 9.4. Any suggestions on how to get past this error?
Thanks in advance.
Hello Leslie,
Sounds like your DIY backup script is almost complete. We just need to get back this database dump error.
Can you please share how you're executing your Bitbucket database backup?
Once we have the above we can see what is causing this and what needs to be done to resolve the issue.
Regards,
Stephen Sifers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Leslie,
Could you please let me know the exact command string you are using with pg_dump?
(Please remove any usernames or passwords, just replace those with admin and password).
Regards,
Stephen Sifers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
prefix=/home/atlassian/bitbucket/backups
suffix=`date +%Y -%m -%d`
# Backup the database
/bin/su - postgres -c /sw1/PostgreSQL/9.4/bin/pg_dumpall | bzip2 > ${prefix}/bitbucket.sq$suffix.bz2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Leslie,
Thank you for sending me your pg_dump string. Reviewing what you sent, the pg_dumpall will attempt to backup every database within postgres at the time of execute. This may be the cause of your error. I would like to try only backing up the Bitbucket database and see what the result is that we get.
Could you please adjust your script to use a pg_dump string as follows:
pg_dump -F t bitbucketdb --no-synchronized-snapshots -f /path/folder
The above will backup only the bitbucket data you set along with creating a tar file of the database back within the path/folder you specify.
There is also additional instructions on creating DIY bitbucket backups at Using Bitbucket Server DIY Backup.
Please let us know the results of your database backup while only backing up bitbucket.
Regards,
Stephen Sifers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the update. I will have to test the command off hours as there are users accessing bitbucket now. I will let you know how I make out.
Thanks,
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.
Hi everyone, We are looking to learn more about development teams’ workflows and pain points, especially around DevOps, integrations, administration, scale, security, and the related challeng...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.