PostgresSql driver version

[Venkatachalam Kannadasan]

Hello Phil,

We are upgrading to version 5 and there is a step in the documentation that says we need to copy the driver from existing glassfish to Payara5.

In our server we have the version  postgresql-9.1-902.jdbc4.jar but the installation documentation has mentioned version postgresql-42.2.9.jar. We want to know whether can we use the latest version that is available at https://jdbc.postgresql.org/download.html?. The latest version is 42.2.19  or should we stick to the older postgresql-42.2.9.jar as indicated in the release note

Also for the newer version of the drivers, as part of maintenance SOP, should we regularly upgrade this file to new versions or should we just stick to whatever version we're using now (i.e. don't upgrade)?

Our preference is to upgrade so that we get new bug fixes and security protections.

Thanks

Venki

[danny...@g.harvard.edu]

Hi Venki, hopefully someone more technical will reply (maybe Phil :)) but there was some work after 5.0 and included in 5.3 that may partially answer your question. There's some discussion in https://github.com/IQSS/dataverse/pull/7420.

[Philip Durbin]

Hi Venki,

My understanding is that the "42" drivers are backward compatible with older versions of PostgreSQL so you should be able to drop the latest version into place.

As indicated in the pull request Danny linked, as of 5.3 we have moved to including the driver in the war file (so you won't have to drop it into place anymore). The version you mentioned, 42.2.19, will be included in the war file as of 5.4. It was upgraded in https://github.com/IQSS/dataverse/pull/7651

In the future, if you notice that a new driver is out, please go ahead and open an issue. It's just a single line in the pom.xml to update.

I hope this helps,

Phil

--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/4001c147-aaee-4081-98e1-f96c6343bee0n%40googlegroups.com.

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin