compatibility matrix between client and server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

compatibility matrix between client and server

Matthias Apitz

Hello,

Is there some matrix about which PG client versions, esp. the shared
libs of ESQL/C can work with which PG server versions. We have a case
where a customer wants to use his own PG server, perhaps even on
Windows, with our 11.4 client version (compiled by us) and used via
ESQL/C.

Thanks

        matthias
--
Matthias Apitz, ‚úČ [hidden email], http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub


Reply | Threaded
Open this post in threaded view
|

Re: compatibility matrix between client and server

Laurenz Albe
On Mon, 2020-09-07 at 11:22 +0200, Matthias Apitz wrote:
> Is there some matrix about which PG client versions, esp. the shared
> libs of ESQL/C can work with which PG server versions. We have a case
> where a customer wants to use his own PG server, perhaps even on
> Windows, with our 11.4 client version (compiled by us) and used via
> ESQL/C.

There is no such matrix, but since the protocol hasn't changed in a long
time, anything but truly ancient servers should work.

The bigger problem is that some of your SQL statements might fail, if
they use syntax that didn't exist back then.

However, if I were you, I'd refuse to support any PostgreSQL major
version that is no longer supported by the project:
https://www.postgresql.org/support/versioning/
So, nothing older than 9.5.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



Reply | Threaded
Open this post in threaded view
|

Re: compatibility matrix between client and server

Ron-2
On 9/7/20 9:06 AM, Laurenz Albe wrote:
[snip]
> However, if I were you, I'd refuse to support any PostgreSQL major
> version that is no longer supported by the project:
> https://www.postgresql.org/support/versioning/
> So, nothing older than 9.5.

That's grossly unrealistic.

--
Angular momentum makes the world go 'round.