Upgrading with PostgreSQL 12

[m.pogorzelski]

Hello,

We have Confluence installed on a Windows machine, running with PostgreSQL 12. 

I was able to install Confluence on it, run it for months without any issues, install apps etc. but when I try to upgrade it says my version is not supported. 

So im not able to upgrade my Confluence installation and have been for several months, when can I expect to upgrade it? 

Greetings

[Kishan Sharma · Accepted solution]

Hi @m.pogorzelski Welcome to Atlassian community.

The latest Confluence server version supports PostgreSQL 11 as per their documentation.

There is an ongoing request with Atlassian to support PostgreSQL12, you can vote for that issue and start watching it for updates.

[m.pogorzelski]

Thank you for the infos! I knew about the request, but: How high are the chances of the request getting accepted and developed when they stopped sales for server licenses? 

I will probably have to find a workaround to get upgrades as this will either take a couple more months or wont happen at all (just stays as it is)

[Kishan Sharma]

Yes you never know, this is something that product team can confirm. Lets hope someone from Atlassian Team replies on this thread.

[Daniel Ebers]

Hi @m.pogorzelski

I am wondering (because you say you are already running your Confluence on PostgreSQL 12) if the error message is something you could potentially ignore. Knowing that it renders you unsupported it is unlikely the new version of Confluence would not cope with version 12 when an older does.

The worst case would be you will not receive support with the information on a database that is unsupported.

In real life (talking to a database specialist some weeks ago) we learned that PostgreSQL is backwards compatible for a few versions going forward - so the probability is rather low that Confluence stops working in your setup.

In case you have a test environment - you could simply test the upgrade and ignore the error message. However, please keep in mind what that means for support - but as we learned you are TODAY already on PostgreSQL 12 this is something you carry with you already.

Regards,
Daniel

[Steve Brine]

First up sorry to hijack this existing thread, I started to post my own question and then this popped up and I am in a similar situation. Getting an "error" from the preflight checks that the DB might not be supported in the new version.

A while ago the server was upgraded to Postgresql 14 and this is what is reporting on a version check

xxxx@SSSSSSS:/tmp# psql --version
psql (PostgreSQL) 14.4 (Ubuntu 14.4-1.pgdg18.04+1)

Confluence (System information) displays the database as 10.22

Database Information

Database name PostgreSQL

Database version 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1)

Database Dialect com.atlassian.confluence.impl.hibernate.dialect.PostgreSQLDialect

Database Driver Name org.postgresql.Driver

Database Driver Version 42.2.18

Database Connection URL jdbc:postgresql://127.0.0.1:5432/confluencedb

Database Connection Transaction Isolation Read committed

Database Latency 0

I just checked and the psql 10 packages are still on the server. Either they weren't removed (most likely) OR the system manager added them back in (main line packages)

So the question I guess is how to make confluence use/see 14 instead of 10 (1. so I can remove and 2. So the new version 7.19 won't error)

Cheers,

Steve B

[Daniel Ebers]

I would recommend start checking if the database actually runs a version "14" but not completely rely on the "psql" command - it could somewhere else.
Unfortunately, overall this is more of a PostgreSQL/Debian question which would be needed to be inspected likely best on the server itself.

Please also ensure to have a backup before installing/uninstalling packages/versions and such.