Migrating from PostgresSQL 9.2 to 9.6+

Question

Hi,

We are currently running Confluence 6.11.1 with PostgresSQL 9.2..24.  The upgrade steps tell me this version of Postgres isn't supported in 7.5 which we would like to upgrade to.  Can anyone give me some direction on the proper methods of upgrading Postgres to a supported version (9.6) before upgrade Confluence?

Also, we are running Jira Core and Server as well.  Should they be upgraded in parallel or can Confluence be upgraded on it's own?

Thanks,

Devin

repi · Answer

My confluence runs on a Pine64 single board computer of the rock64 type in credit card format.
A modified Debian is used as the operating system.
An update is carried out using the typical update routine apt update followed by apt list --upgradeabel.
There I recognize, before I start the actual update, whether an update of the psotgresql server is pending.
So far, I never had to make any manual changes to the postgresql db after going through the upgrade.

Unfortunately, I cannot say whether the procedure you linked is part of my update.

To backup the db I use pg_dump (for confluence db) and pg_dumpall.

Devin Sijan · Answer

Are you using something like this?  https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/

Devin Sijan · Answer

repi,

Thanks so much for those details.  I'd like to pick your brain a bit more here.  Based on what I had been reading before, I needed to setup a new postgres instance on 9.6, take a DB dump of the old postgres instance and start it up on the new.

When you're calling out the "postgres linux update routine" are you simply referring to yum update or the same?

Appreciate it!

Devin