correct postgresql driver

[Sverre Moe]

According to the supported platforms:

• 9.3 with the PostgreSQL Driver 9.3.x
• 9.2 with the PostgreSQL Driver 9.2.x
• 9.1 with the PostgreSQL Driver 9.1.x

JIRA comes bundled with postgresql-9.0-801.jdbc4.jar

Our JIRA is using Postgresql 9.1.12

Seems there is a mismatch of database and driver version. Though it is working fine with the 9.0 jdbc-driver.

Would there be any benefits of upgrading to a newer database driver for Postgresql 9.1:

https://jdbc.postgresql.org/download/postgresql-9.1-903.jdbc4.jar

If using Postgresql 9.3, is there any benefits of using JDBC41

https://jdbc.postgresql.org/download/postgresql-9.3-1103.jdbc41.jar

[Daniel Santos]

Hi Sverre,

    I don't believe there are any advantages by changing it, although seems to be the right thing to do. JIRA will not use the new features available in this new drivers since it was tested with the bundled JDBC 9.0. There are lots of customers that have JDBC 9.0 with newer versions of Postgres. Also there are customers with the JDBC matching the Postgres version. As far as I know you won't have any problem, but you can also update it to a newer version.

Best regards,

Daniel P Santos