Обсуждение: RE: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Hi Deepti,

By using an older client, you will be missing out on the additional
features that Postgres 11 (and its corresponding client) supports. By
referring to the release notes, you can identify those:
https://www.postgresql.org/docs/release/11.0/

You can generally use an older client with a new release, but for the
above reasons you should try to match server and client versions.

Best regards
Jimmy

Jimmy Angelakos
Senior PostgreSQL Architect
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/

On Fri, 13 Mar 2020 at 08:19, Deepti Sharma S
<deepti.s.sharma@ericsson.com> wrote:
>
> Hello Team,
>
>
>
> Can anyone help us to answer below query.
>
>
>
>
>
> DEEPTI SHARMA
> Specialist
> ITIL 2011 Foundation Certified
> BDGS, R&D
>
>
> Ericsson
> 3rd Floor, ASF Insignia - Block B Kings Canyon,
> Gwal Pahari, Gurgaon, Haryana 122 003, India
> Phone 0124-6243000
> deepti.s.sharma@ericsson.com
> www.ericsson.com
>
>
>
> From: Deepti Sharma S
> Sent: Monday, March 2, 2020 3:20 PM
> To: 'postgres-discuss@mailman.lmera.ericsson.se' <postgres-discuss@mailman.lmera.ericsson.se>
> Subject: PostgreSQL10.x client Vs. PostgreSQL 11.x server
>
>
>
> Hello Team,
>
>
>
> Can you please confirm the compatibility of PostgreSQL 10.x client with PostgreSQL 11.x server.
>
>
>
>
>
>
>
> DEEPTI SHARMA
> Specialist
> ITIL 2011 Foundation Certified
> BDGS, R&D
>
>
> Ericsson
> 3rd Floor, ASF Insignia - Block B Kings Canyon,
> Gwal Pahari, Gurgaon, Haryana 122 003, India
> Phone 0124-6243000
> deepti.s.sharma@ericsson.com
> www.ericsson.com
>
>

On 2020-03-13 08:47:59 +0000, Jimmy Angelakos wrote:
> By using an older client, you will be missing out on the additional
> features that Postgres 11 (and its corresponding client) supports.

This is not correct. You can use all the additional features which only
affect the server. None of the major enhancements mentioned at the start
of the release notes (partitioning, parallelism, stored procedures, JIT,
...) should depend on the client.

I am talking about low level client libraries here, like libpq or a
ODBC, JDBC or DBD driver. An ORM or similar framework may well depend on
server-side enhancements. Also, client programs (e.g. psql) may also
have some enhancements.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"