pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-admin@postgresql.org
Subject: Re: Compatibility between different versions of psql client and postgresql server
Date: Sat, 28 Aug 2004 14:28:16 -0000
Message-ID: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com> (raw)
In-Reply-To: <cgml7r$3a9$1@floppy.pyrenet.fr>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
> 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?
 
The basic rule is: use the same version for both.
 
> For example, is it possible to connect from psql 7.2.x to postgresql
> server 7.4.x?
 
This one is possible, but anytime you mix versions, you will probably have
problems. Since psql is part of the main PostgreSQL distribution, if
you have the 7.4.x server, you should have the 7.4.x psql as well. 7.2.x
(the server) is rather old and has some serious issues, and it should not
be used. In general, going from an older psql to a newer server will cause
less problems than going the other way.
 
Having said all of that, there is an effort underway to try and
make psql a little more forgiving. The 8.0 version can work against 7.4
servers, and I'm going to try and keep things relatively portable as we
move forward from 8.0. However, it will never work against 7.2 servers
(too many changes from 7.2->7.3 to make it worth the trouble) and *may*
at some point read 7.3 servers, but that gets less likely as time moves on.
 
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200408281026
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFBMJaxvJuQZxSWSsgRAp6GAJ9CqChJdRlpL5OLEOHNCLmxvc0NOgCdFD6c
6085Mq0GOiwQV5Fm2PPa2b4=
=H7GW
-----END PGP SIGNATURE-----





view thread (4+ messages)  latest in thread

Message-ID: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com>
Permalink:  ../8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com/
Also on:    postgresql.org/message-id/8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: greg@turnstep.com
  Subject: Re: Compatibility between different versions of psql client and postgresql server
  In-Reply-To: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com>
  References: <cgml7r$3a9$1@floppy.pyrenet.fr> <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox