nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DIY Bitbucket backup with postgreSQL fails with unable to lock database

lhaynes4

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.

Accepted answers

All comments

Stephen Sifers

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

lhaynes4

Hello Stephen,

I am using pg_dump to backup the database.

Stephen Sifers

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

lhaynes4

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

bitbucket

bitbucket-server