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

Confluence Postgres DB backup and restoration Edited

Hi All,

I have a question on postgres confluence DB backup and restoration process. We tried to backup our confluence PROD DB and restore them in Dev instance by


Stopping confluence
Updating the DB details in confluence.cfg.xml file
Restarting confluence and performing a content indexing.

We do not need the attachments and hence we have not restored the confluence home directory.

The system info page of our Dev instance is showing number of spaces, contents, site spaces, user groups, personal spaces matching our PROD instance, however the DB size of prod confluence and dev confluence doesn't match. Unable to find any missing data. Import of PROD data to a new database completed without any errors.

 

We ran this query to check the DB size

SELECT pg_size_pretty(pg_database_size(current_database())) as size;

 

A diff of 13G is seen between PROD and Dev instance databases

Any thoughts?

2 answers

1 accepted

0 votes
Answer accepted
Daniel Ebers Community Leader Oct 29, 2020

Hi Niranjan,

I assume you used the pg_dump command and restored via psql like described by Stephen?

If so, the diff in size is most likely just normal.
I found a explanation on the "why" here - in case you want to read through the backgrounds.

Cheers,
Daniel

It's possible that you are missing data, or you could just me missing the page history. Either way you'll probably want to do a postgres dump and restore to make sure you have all the data. The process looks like this:

1) Stop production confluence 

2) Take a database dump

pg_dump dbname > dumpfile

3) Move the dump file to new confluence db server 

4) Stop Dev confluence

5) Restore database from db dump

psql dbname < dumpfile

 6) Start Dev Confluence

A postgres dump drops all the data into a single file, which can be transferred and reimported.

You can read more about this here: https://www.postgresql.org/docs/9.5/backup-dump.html

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
6.13.4
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

198 views 0 6
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