Thread: Where is client/server compatibility documented?

Where is client/server compatibility documented?

From
Wes
Date:
Where can I find documentation on what client library version interoperate
with which server versions?  I've been unable to find anything in the manual
or archives.  The only thing I've found is some information in the archives
on certain psql versions.  Is there a compatibility matrix somewhere for the
client libraries?

Specifically, I have a C application (ecpg/libpq), as well as perl DBI,
built against PostgreSQL 7.4.1.  Am I safe in upgrading the server to 8.1.3
before the application can be rebuilt?  I've seen no problems on the test
server, but...

There's no system catalog monkey business - just plain old SQL.

Wes



Re: Where is client/server compatibility documented?

From
Scott Marlowe
Date:
On Thu, 2006-04-13 at 15:06, Wes wrote:
> Where can I find documentation on what client library version interoperate
> with which server versions?  I've been unable to find anything in the manual
> or archives.  The only thing I've found is some information in the archives
> on certain psql versions.  Is there a compatibility matrix somewhere for the
> client libraries?
>
> Specifically, I have a C application (ecpg/libpq), as well as perl DBI,
> built against PostgreSQL 7.4.1.  Am I safe in upgrading the server to 8.1.3
> before the application can be rebuilt?  I've seen no problems on the test
> server, but...
>
> There's no system catalog monkey business - just plain old SQL.

The latest libs that come with 8.1 can talk to any client that talks the
V2 or V3 protocol, which takes you back to 7.0 or 6.5 or something like
that.  Maybe even earlier.