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

How to restore Bitbucket Pull Requests data from a PostgreSQL backup

Mike Quentel June 28, 2023

Recently, there was a server crash that corrupted a repo in Bitbucket (self-hosted server edition running on CentOS 7). Eventually, using the Bitbucket user interface, I re-created the repo, which deleted everything from the old version, including Pull Requests (PRs).

Then, I also successfully restored the commit history from existing objects on the server and copies of objects from users. Example:


I have a backup of the server where PostgreSQL held PRs. The new repo is currently in use, and has new PR data in its corresponding PostgreSQL table. I would like to be able to restore the missing rows of data pertaining to PRs into the current PostgreSQL database.

Using SQLectron, I can see there is a table


that appears to have PR data. I also see similar tables that appear to have PR data.

Does anyone know what tables I should examine and use for restoring the PR data? Also, open to other advice on the approach here.

Many thanks.

1 answer

1 accepted

0 votes
Answer accepted
Mike Quentel June 28, 2023

Per Investigating Bitbucket Server Database Schema I downloaded DBVisualizer which has built-in graphing functionality showing a diagram for the Bitbucket database. This at least points me in the right direction.

Screenshot of the diagram in DBVisualizer:


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events