PostgreSQL 10.10

[Tony Gottfridsson]

So we're running most *nix on the current Ubuntu LTS server platform. When Confluence and Jira started complaining about postgres version being to old I migrated the data to a new server running ubuntu 18 and upgraded our atlassian product to the newset available today, This means psql 10.10.

Confluence doesn't complain about postgresql 10.10 even though 9.6 seems to be the newest compatibla version. Jira on the other hand complains about 10.10 and wants 9.6. Things seems to be working fine except for the complains, not really sure what problems might be comming our way because of this, but downgrading to 9.6 is definately not happening, I'd sooner throw Jira out the door.

Whats the roadmap on bringing the atlassian product in line with currently "fresh and default" postgresql versions?

/Tony

[Stephen Sifers · Accepted solution]

Hello Tony and welcome to the Community!

Glad to hear you’re on top of your PostgreSQL updates and ensuring you’re running a recent and patched version. With this said, and as you confirmed, PostgreSQL 10 is not officially supported just yet (as of the time of this post). While you can most certainly run Jira using PostgreSQL 10, do understand if you run into an issue with the database it will be deemed as unsupported.

Now with that out of the way, we do have feature requests to bring PostgreSQL 10 support into both Jira and Confluence. You may find these feature requests at JRASERVER-65910 and CONFSERVER-57666. We would ask for you to vote and watch these requests for future updates.

Most importantly, the Jira request is currently (at the time of this answer) in progress which means we’re evaluating this feature to be added in the future.

I hope this information proves helpful.

Regards,
Stephen Sifers

[Dario B]

Hi @Tony Gottfridsson ,

Let me try to add some context to what has already been written by my colleague @Stephen Sifers .

Not being on the latest release available is perfectly normal since for something to be officially supported extensive testing is needed and this can take a lot of time. Also, it is perfectly normal that older releases support older versions of PostgreSQL.

To provide a matching example, this is happening in Ubuntu as well:

• the latest PostgreSQL version available at the moment is version 11
• the latest PostgreSQL version available in the latest Ubuntu LTS release (18.04) repositories is 10.10

Once this has been said, please also notice that even if newer versions are not officially supported, it does not mean that they don't work. This is also explicitly stated for the JDBC driver in the Supported platform for Jira 8.4 page:

Jira is tested and bundled with the 9.4 JDBC driver. You can also use the latest JDBC driver for your PostgreSQL version, though we can't guarantee it will work with your version of Jira. To use a different JDBC driver:

1. Stop your Jira instance.
2. Remove the bundled driver from <JIRA_INST>/lib/.
3. Download the new driver and place it in <JIRA_INST>/lib/.
4. Restart your Jira instance.

!!! Jira 8.x Warning !!!! 
!!! Jira does not support reducing the blocksize parameter below its default value. !!! 

Finally, not sure if this can help in any way, but please be aware that there is an official PostgreSQL repository available for Debian/Ubuntu (and other distributions using apt) from which you can install any old or new PostgreSQL release using apt.

For more details on this see: 

• PostgreSQL Linux downloads (Ubuntu)
• PostgreSQL packages for Debian and Ubuntu

Cheers,
Dario