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:

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!"

Hi Jimmy,

If I would change my question, that if customer will be having PostgreSQL client 11.x version and PostgreSQL 10.x as server, will that be compatible?

[Ericsson]<http://www.ericsson.com/&gt;
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<mailto:deepti.s.sharma@ericsson.com>
www.ericsson.com<http://www.ericsson.com/&gt;

From: Jimmy Angelakos <jimmy@2ndquadrant.com>
Sent: Friday, March 13, 2020 2:17 PM
To: Deepti Sharma S <deepti.s.sharma@ericsson.com>
Subject: 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<mailto:deepti.s.sharma@ericsson.com>> wrote:
Hello Team,

Can anyone help us to answer below query.

[Ericsson]<http://www.ericsson.com/&gt;
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<mailto:deepti.s.sharma@ericsson.com>
www.ericsson.com<http://www.ericsson.com/&gt;

From: Deepti Sharma S
Sent: Monday, March 2, 2020 3:20 PM
To: 'postgres-discuss@mailman.lmera.ericsson.se<mailto:postgres-discuss@mailman.lmera.ericsson.se>' <postgres-discuss@mailman.lmera.ericsson.se<mailto: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.

[Ericsson]<http://www.ericsson.com/&gt;
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<mailto:deepti.s.sharma@ericsson.com>
www.ericsson.com<http://www.ericsson.com/&gt;

Hi Deepti,

As Peter pointed out (and I should have clarified), the server-side
features of each version should work regardless of client.
So the pg11 client will support all of the features of pg10 server (should
be fully compatible).

Best regards,
Jimmy

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