When you doing a site backup does it backup the PostgreSQL database as well?

[Joshua Kacen]

When you doing a site backup does it backup the PostgreSQL backup as well?

Also, at what filesize do recommend changing from using the confluence on-board automatic backup to a manual process?

[Nic Brough -Adaptavist-]

Just to be clear, it does NOT do a Postgres export/dump, it exports all the data from the database to XML that Jira can read.

[Joshua Kacen]

Does this XML file enable you to do a complete site restore? Assuming the database has been created in PostgreSQL first.

[Nic Brough -Adaptavist-]

Yes, it contains everything except the server configuration (the system files in the installation) and the attachments, which need to be backed up from the file system under /<confluence home>/attachments (If you're on Cloud, then they are added to the xml as Edwin mentions)

[Edwin Kyalangalilwa]

Hi @Joshua Kacen ,

Yes, it backups all content into an XML.

Please take a look at Site Backup and Restore

That depends on your instance sizing: spaces count, content count, number of users and groups and also number of add-ons being used. Information can be found under System Information

Atlassian recommends the manual process for production instances.