Re: client backwards compatible with older servers

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Rajesh Madiwale <rajeshmadiwale65(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: client backwards compatible with older servers
Date: 2021-04-30 08:08:11
Message-ID: CAM+6J96EJtELEpctvh-ByqzE_O5m8SzGY1+gTvsbbM1k3bACzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am not sure which postgresql client is being referred to.
If it is psql command line then from the notes section of the docs below
says

https://www.postgresql.org/docs/current/app-psql.html

psql works best with servers of the same or an older major version.
Backslash commands are particularly likely to fail if the server is of a
newer version than psql itself. However, backslash commands of the \d family
should work with servers of versions back to 7.4, though not necessarily
with servers newer than psql itself. The general functionality of running
SQL commands and displaying query results should also work with servers of
a newer major version, but this cannot be guaranteed in all cases.

If you want to use psql to connect to several servers of different major
versions, it is recommended that you use the newest version of psql.
Alternatively, you can keep around a copy of psql from each major version
and be sure to use the version that matches the respective server. But in
practice, this additional complication should not be necessary.
If it is language specific clients, I guess you may have to talk to the
maintainers of those libraries/ clients.

Thanks,
Vijay

On Fri, Apr 30, 2021, 1:21 PM Rajesh Madiwale <rajeshmadiwale65(at)gmail(dot)com>
wrote:

> Hi Team,
>
> Do we have any reference documentation which tells above postgres client's
> backward compatibility ?
> Example: I am having PG server installed is PG-11.8 and PG client
> installed is PG-13 , will I face any issue? or are there any limitations if
> I use it ?
>
> Regards,
> Rajesh Madiwale.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Rißler 2021-04-30 08:49:34 Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
Previous Message Rajesh Madiwale 2021-04-30 07:51:35 client backwards compatible with older servers