RE: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

RE: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Deepti Sharma S

Hello Team,

 

Can anyone help us to answer below query.

 

 

Ericsson

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
[hidden email]
www.ericsson.com

 

From: Deepti Sharma S
Sent: Monday, March 2, 2020 3:20 PM
To: '[hidden email]' <[hidden email]>
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

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
[hidden email]
www.ericsson.com

 

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Jimmy Angelakos-3
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
<[hidden email]> 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
> [hidden email]
> www.ericsson.com
>
>
>
> From: Deepti Sharma S
> Sent: Monday, March 2, 2020 3:20 PM
> To: '[hidden email]' <[hidden email]>
> 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
> [hidden email]
> www.ericsson.com
>
>


Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Peter J. Holzer
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.
|_|_) |                    |
| |   | [hidden email]         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Deepti Sharma S
In reply to this post by Deepti Sharma S

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

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
[hidden email]
www.ericsson.com

 

From: Jimmy Angelakos <[hidden email]>
Sent: Friday, March 13, 2020 2:17 PM
To: Deepti Sharma S <[hidden email]>
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 <[hidden email]> wrote:

Hello Team,

 

Can anyone help us to answer below query.

 

 

Ericsson

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
[hidden email]
www.ericsson.com

 

From: Deepti Sharma S
Sent: Monday, March 2, 2020 3:20 PM
To: '[hidden email]' <[hidden email]>
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

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
[hidden email]
www.ericsson.com

 

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server

Jimmy Angelakos-3
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/