Upgrade confluence and DB version

[Karin Heijboer]

I have a server installation of Confluence on a Windows Server2012 R2

I currently have:
- Confluence 6.2.1
- Postgres 9.5

I want to migrate to:
- Confluence 6.9
- Postgres 9.6

What is the best approach for this?
Postgres 9.6 is not supported on Confluence 6.2.1. So I assume I first need to upgrade Confluence using the installer. 
I can install the new Postgres 9.6 and move the confluence DB to this new Postgres server. Will confluence automatically recognize this new server (as long as the port is the one from the old Postgres 9.5 server)?

[Lipkent Ng · Accepted solution]

Hi

You can first upgrade confluence to the version that supports both prostgres9.5 and 9.6 and proceeds to upgrade the database.

If you are planning to install a new Postgres 9.6, you can first upgrade confluence, generate a database dump from Postgres 9.5 and restore it to Postgres 9.6. After that, you will need to modify the confluence.cfg.xml file in confluence home directory to point to the Postgres 9.6. Confluence read the confluence.cfg.xml file to identify the location of the database and connect to it.

(i) You may want to generate a database ump backup and a backup of confluence home and installation directory to avoid any data loss or corruption. If possible do perform testing.

[Karin Heijboer]

Thanks for your help. I have done the upgrade and migration to the new DB version. It worked perfectly.