Upgrade confluence and Postgres DB version?

[V MALLIKARJUNA]

Currently we are using Confluence 6.15.9v & Postgresql 9.3.25 Version

we are planning to upgrade confluence from 6.15.x to 7.19.x version

Postgres 9.3.25 is not supported for confluence 7.19.x version

how we can upgrade DB & Confluence

[Ravina]

Hi @V MALLIKARJUNA Upgrading the local installed database is a tricky and error pone method so I will recommend that do not upgrade the existing database if you don't have dedicated DBA team, as you plan to upgrade to 7.19.x from 6.15.x and 7.19.x is supported to PostgreSQL 11 not less than that.

My recommendation is to install the PostgreSQL 11 version database by uninstalling the the existing if you want to install the database locally, check if you OS is supported the PostgreSQL 11 as there will be lot of database dependency issues you will face, but you can install those dependencies and install the PostgreSQL 11.

If your org is okay to connect your application to the database created on cloud instances like AWS, Azure, etc then please try that option and create a database there and upgrade the existing Confluence to v 7.19.x and then connect the database to this newly created database, before upgrading the Confluence take a XML backup from the instance and once you connect the same to new database then import that XML backup to the new database.

You can import the XML backup exported from the lower version of Confluence to the higher version.

Note: Perform all these changes in the Stage/lower instances to confirm if everything works fine and then plat the production upgrade.

You can follow the below documents for the database and Confluence upgrade

https://www.postgresql.org/docs/9.3/pgupgrade.html

https://gist.github.com/ShvaykaD/313745d31a9af6db3d6a01ec9f16aac8

https://confluence.atlassian.com/doc/upgrading-confluence-4578.html

https://confluence.atlassian.com/doc/confluence-7-19-upgrade-notes-1141976787.html

Thanks

Ravina