Skip site navigation (1) Skip section navigation (2)

Re: Compatibility between different versions of psql client and postgresql server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Compatibility between different versions of psql client and postgresql server
Date: 2004-08-28 16:27:58
Message-ID: 20106.1093710478@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
>> When connecting from a psql client version xyz to a postgresql server
>> version zyx across the network, what are the rules to follow for
>> assuring compatibility between different versions?

> [snip]
> ... In general, going from an older psql to a newer server will cause
> less problems than going the other way.

One other point is that just connecting and issuing SQL queries should
work, more or less independently of which psql and backend mix you're
using.  What is likely to fail is psql's backslash commands, because
those have hard-wired knowledge about the system catalogs, which change
from version to version.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-08-28 16:54:15
Subject: Re: Postgresql Server Restart continuously
Previous:From: Greg Sabino MullaneDate: 2004-08-28 14:28:16
Subject: Re: Compatibility between different versions of psql client and postgresql server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group