Thread: compatibility matrix between client and server

compatibility matrix between client and server

From
Matthias Apitz
Date:
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, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub



Re: compatibility matrix between client and server

From
Laurenz Albe
Date:
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




Re: compatibility matrix between client and server

From
Ron
Date:
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.