pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Compatibility between different versions of psql client and postgresql server
4+ messages / 4 participants
[nested] [flat]

* Compatibility between different versions of psql client and postgresql server
@ 2004-08-27 06:43 Cris Carampa <cris119@operamail.com>
  2004-08-28 14:28 ` Re: Compatibility between different versions of psql client and postgresql server Greg Sabino Mullane <greg@turnstep.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Cris Carampa @ 2004-08-27 06:43 UTC (permalink / raw)
  To: pgsql-admin

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?

For example, is it possible to connect from psql 7.2.x to postgresql 
server 7.4.x?

Thank you. Kind regards,

-- 
Cris Carampa (spamto:cris119@operamail.com)
I got some John Coltrane on the stereo baby make it feel all right
I got some fine wine in the freezer mama I know what you like
I said a man works hard all day he can do what he wants to at night



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Compatibility between different versions of psql client and postgresql server
  2004-08-27 06:43 Compatibility between different versions of psql client and postgresql server Cris Carampa <cris119@operamail.com>
@ 2004-08-28 14:28 ` Greg Sabino Mullane <greg@turnstep.com>
  2004-08-28 16:27   ` Re: Compatibility between different versions of psql client and postgresql server Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Greg Sabino Mullane @ 2004-08-28 14:28 UTC (permalink / raw)
  To: pgsql-admin


-----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-----





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Compatibility between different versions of psql client and postgresql server
  2004-08-27 06:43 Compatibility between different versions of psql client and postgresql server Cris Carampa <cris119@operamail.com>
  2004-08-28 14:28 ` Re: Compatibility between different versions of psql client and postgresql server Greg Sabino Mullane <greg@turnstep.com>
@ 2004-08-28 16:27   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2004-08-28 16:27 UTC (permalink / raw)
  To: pgsql-admin

"Greg Sabino Mullane" <greg@turnstep.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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Compatibility between different versions of psql clientand postgresql server
@ 2004-08-30 16:51 Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Naomi Walker @ 2004-08-30 16:51 UTC (permalink / raw)
  To: Greg Sabino Mullane <greg@turnstep.com>; +Cc: pgsql-admin

Test - Please ignore 

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-08-30 16:51 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-27 06:43 Compatibility between different versions of psql client and postgresql server Cris Carampa <cris119@operamail.com>
2004-08-28 14:28 ` Greg Sabino Mullane <greg@turnstep.com>
2004-08-28 16:27   ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-30 16:51 Re: Compatibility between different versions of psql clientand postgresql server Naomi Walker <nwalke@eldocomp.com>

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