Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,617
Community Members
 
Community Events
168
Community Groups

Upgrading with PostgreSQL 12

Edited

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

 

2 answers

1 accepted

0 votes
Answer accepted
Kishan Sharma Community Leader Aug 31, 2021

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.

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 Community Leader Aug 31, 2021

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

0 votes

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Watch 4 Confluence apps compete for Best App Demo in September's Appy Hours

Calling all collaborators! Appy Hours on the Atlassian Community is a monthly event where 4 Partner and app vendor presenters go head-to-head with 5-minute demos for the title of Best App Demo. I...

594 views 0 13
Read article

Atlassian Community Events