Rudder

According to http://jdbc.postgresql.org/download.html , the version we should be using is 9.3-1100 JDBC4 (as we are supporting Java 1.6)

and stackoverflow confirms that
http://stackoverflow.com/questions/18392170/does-a-jdbc-drivers-version-and-a-dbs-version-have-to-match-exactly

Cool, thanks!

François ARMAND wrote:

Today (Rudder 2.8), we use the postgresql "8.4-702.jdbc4" driver version. I'm seing that there exists both jdbc4/jdbc3 version of the driver, and 8.1, 8.2, 8.3, 8.4, 9.0, 9.1... etc version of the driver.

For the JDBC part, it's easy: we need JDBC4.

But do we must ensure that the PostgreSQL driver matches the PostgreSQL DB version ? Or can we simply use the most recent driver, and assume it will work on (not too old) past Postgres version ? Or contrary, do we need to use the driver corresponding to the oldest Postgresql version we support?

It is impossible to know which version of PostgreSQL will be used on any given server. Our packages simply depend on "postrgesql", and according to the target OS and it's versions, and also the available repos (eg EPEL on CentOS/Red Hat), any version from 8.x to 9.x may be installed.

However, using the latest version because it supports the older ones as well seems perfect - great stuff! Where is this being fixed?

For currently supported version and upward, we now use the latest available version of the drivers.