Thread: client backwards compatible with older servers

client backwards compatible with older servers

From
Rajesh Madiwale
Date:
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.

Re: client backwards compatible with older servers

From
Vijaykumar Jain
Date:
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


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@gmail.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.