Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

 

1 answer

1 accepted

0 votes
Answer accepted

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 Atlassian Team Oct 09, 2019

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: 

 

 

Cheers,
Dario

Like Stephen Sifers likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

326 views 9 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you