javapostgresqlspring-bootspring-data-jpaversion-compatibility

How to check Postgres version compatibility with spring data jpa?

I have been using Postgres version 10.6 in my spring-boot project but now we are going to upgrade the Postgres version from 10.6 to 13.6. how should I check the version compatibility of the Postgres 13.6 with my current code? I am using spring-data-jpa.

Solution

  • It comes down to the version of your spring-data-jpa dependency in your project.

    As a quick reference, latest spring-data-jpa v2.7.x uses the following PostgreSQL jdbc version:

    <postgresql>42.2.19</postgresql>

    On another hand, recent pgjdbc versions are all compatible with PostgreSQL 8.2 and higher, and Java 8 (JDBC 4.2) and higher as per this link

    Therefore, it is all about checking the version of spring-data-jpa you are using, and upgrading to PostgreSQL 13 should prove no issues when you do.