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.
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
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.