Migrating from PostgresSQL 9.2 to 9.6+

[Devin Sijan]

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]

@Devin Sijan 

Postgresql runs under which operating system?

If under Linux, just start the update. The DB is automatically integrated into the new version.
I would also switch all applications (Jira, confluence...) to the new version, otherwise you would have to run two postgresql servers in parallel.

[Devin Sijan]

Hi,

Just to confirm, are you saying an update of the DB to 9.6 isn't required?

[repi]

Hi,
I have been using postgresql under linux as a DB for my private confluence for several years. If there is an update for postgresql, I always proceed as follows:
1. stop confluence
2. call the postgresql linux update routine
3. after the update check whether postgresql is running
4. Start confluence

My confluence makes an automatic backup every day, as does the postgresql confluence db.
If something goes wrong! :)

[Devin Sijan]

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

[Devin Sijan]

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/

[repi]

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.