Confluence Postgres DB backup and restoration

Niranjan

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?

Daniel Ebers

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