X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB4F65E46E7 for ; Sat, 28 Aug 2004 11:28:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87940-10 for ; Sat, 28 Aug 2004 14:28:13 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id A55CB5E46FB for ; Sat, 28 Aug 2004 11:28:10 -0300 (ADT) Received: (qmail 32361 invoked from network); 28 Aug 2004 14:28:17 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 28 Aug 2004 14:28:17 -0000 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: Compatibility between different versions of psql client and postgresql server X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Date: Sat, 28 Aug 2004 14:28:16 -0000 X-Mailer: JoyMail 1.48 Message-ID: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/296 X-Sequence-Number: 14691 -----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-----