How to check Postgres version compatibility with spring data jpa?

4k views Asked by At

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.

1

There are 1 answers

0
John Chan On BEST ANSWER

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.