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 712E05E46F4 for ; Sat, 28 Aug 2004 13:27:54 -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 16841-06 for ; Sat, 28 Aug 2004 16:28:01 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D0A0E5E46F2 for ; Sat, 28 Aug 2004 13:27:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7SGRxCt020107 for ; Sat, 28 Aug 2004 12:27:59 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Compatibility between different versions of psql client and postgresql server In-reply-to: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com> References: <8a456d9c6f2de83ab21734808cfbd5f4@biglumber.com> Comments: In-reply-to "Greg Sabino Mullane" message dated "Sat, 28 Aug 2004 14:28:16 -0000" Date: Sat, 28 Aug 2004 12:27:58 -0400 Message-ID: <20106.1093710478@sss.pgh.pa.us> From: Tom Lane 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/297 X-Sequence-Number: 14692 "Greg Sabino Mullane" 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