Update postgresql driver

Support
#1

Hi,

Working on deploying my CUBA app on Google Cloud (app engine flexible) with Cloud SQL postgresql I was forced to updated the postgresql dependency, and noticed my 7.0 gradle file says:

def postgres = 'org.postgresql:postgresql:9.4.1212'

This is like 2 years old atleast, current is:

def postgres = 'org.postgresql:postgresql:42.2.5'

After updating I can now use the google socket factory and cloud sql properly.

Is there anything forcing CUBA to still default to such an old postgresql driver version? If not, please update the default to latest on cuba 7 release!

#2

Hi Marc,

Thank you for the feedback. We’ll update the JDBC drivers for the next feature release (7.1), as we need more time for testing. Created issue.
Please report if you have any trouble upgrading the driver version in your project.

Regards,
Konstantin

#3

If you need evidence, we use:

postgres = [group: ‘org.postgresql’, name: ‘postgresql’, version: ‘42.2.4’]

in production without problems.

So I would vote to update the driver in 7.0.

There can be compilation incompatibilities though if the project uses postgres JDBC driver custom features such as PGPolygon, hstore etc.

Regards,
Alexander.

1 Like
#4

Accepted: another issue