How do I upgrade the PostgreSQL driver?

In the JIRA system requirements, supported platforms documentation it states that PostgreSQL version 9.3 is supported with PostgreSQL driver 9.3.x.  My JIRA installation came bundled with a PostgreSQL driver, but I don't know which version. The bundled driver seems to work fine with PostgreSQL 9.3.5, but to be on a supported platform, I need it upgraded. I know this should be easy, but I don't know which jar file to replace. Please advise. 

1 answer

This widget could not be displayed.

I am not sure why you think you need to upgrade the driver to be on a supported platform.   If anything, you are potentially invalidating your JIRA installation since you are changing the supported postgreSQL driver.

You did not state which OS, but I will assume Linux.   Please see step two in the following document where to look for the jar file.

https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+PostgreSQL#ConnectingJIRAtoPostgreSQL-2.CopythePostgreSQLJDBCdrivertoyourapplicationserver(JIRAWARonly)

The very first thing that the above referenced instructions tell you to do is to "See Supported Platforms" at the following link: https://confluence.atlassian.com/display/JIRA/Supported+Platforms When you scroll down to the PostgreSQL section it states the Supported Version is "9.3 with the PostgreSQL Driver 9.3.x". In fact, every supported version of PostgreSQL specifies which driver it is to be paired with. Yes, this is on Linux. Step two indicates it is applicable to "JIRA WAR Only", which mine is not. I understand the WAR distribution does not come bundled with a PostgreSQL driver. If I follow these instructions, I will have two PostgreSQL drivers - the one that came bundled and the one I installed. That is why I assumed I needed to replace the bundled driver with the one that is "Supported" to work with my PostgreSQL database version. If I'm worrying about nothing, then fine, but the documentation is really ambiguous.

Your question was where the driver was located so you can replace it. The location is suppose to be the same across the installations, so WAR documentation told you where. That is the only reason I pointed you at the WAR docs. I assumed you would replace the driver so there was only one driver. As you already stated there is nothing to worry about.

Well, now that I have gone back and looked again, I see that the bundled jar file is postgresql-9.0-801.jdbc4.jar. I suppose that's the one I would replace, duh. Sorry for the stupid question. New question - would it hurt to upgrade the driver, and is it as simple as replacing the jar file?

Hard to say, since I have not done it. I would expect a build number change only (801) would probably work even if you needed to rename the updated file with build number 801. A version number change is problematic since there is higher probability that interfaces could change. I did not see in the documentation that I looked at that you need to specify the driver file path anywhere.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

220 views 3 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you