How do I upgrade the PostgreSQL driver?

Question

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.

Norman Abramovitz · Answer

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.

Joe Detjen1 · Answer

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?

Norman Abramovitz · Answer

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.