Re: version 42.2.3 postgresql 12.5 compatibility

In general, the protocol of Postgres doesn't change, so the driver "might"
work with newer versions of Postgres, the trouble comes if there are
catalog changes and you query the metadata information or some parts that
might require special handling.

The jdbc driver even test on CI the master branch of postgres, so it
"should" work with the latest unreleased PostgreSQL 14 version, but please
note that even if it should work, that doesn't mean that it implements new
functionally from that version (this as always from the latest version of
the driver).

Generally speaking, you should always try to use the latest version of the
jdbc driver and don't be stuck with a specific version, you will get small
improvements and bug fixes, but as usual, always make your own tests to
make sure everything works correctly, in your case, as is a third party
product, you might need to verify the compatibility with the vendor.

Regards,

On Thu, May 6, 2021 at 10:27 AM Branislav Kalas <bkalas(at)gmail(dot)com> wrote:

> Hi guys,
> we are using third party product with bundled jdbc driver in version 42.2.3
> Now postgres is going to be upgraded from 9.5 to 12.5
> So far local tests are working also with 42.2.3 driver.
>
> What is confusing me i went through changelogs of drivers and in 42.2.6 i
> saw this message
> Added
>
> - CI tests with Java 11, and Java EA
> - Support temporary replication slots in ReplicationCreateSlotBuilder PR
> 1306 <https://github.com/pgjdbc/pgjdbc/pull/1306>
> - *Support PostgreSQL 11, 12*
>
>
> Does that mean that 42.2.6 is first version supporting pg 12, or 42.2.3
> should work with pg12 as well?
>
> Thanks for answer
>
> --
> bkalas
>
>