compatibility matrix between client and server

Started by Matthias Apitzover 5 years ago3 messagesgeneral
Jump to latest
#1Matthias Apitz
guru@unixarea.de

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

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Matthias Apitz (#1)
Re: compatibility matrix between client and server

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

#3Ron
ronljohnsonjr@gmail.com
In reply to: Laurenz Albe (#2)
Re: compatibility matrix between client and server

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.