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 4E7C38B9F28 for ; Fri, 4 Feb 2005 18:41:27 +0000 (GMT) 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 37772-02 for ; Fri, 4 Feb 2005 18:41:24 +0000 (GMT) Received: from franklin.pc.umiacs.umd.edu (franklin.pc.umiacs.umd.edu [128.8.118.14]) by svr1.postgresql.org (Postfix) with ESMTP id 973BC8B9F18 for ; Fri, 4 Feb 2005 18:41:23 +0000 (GMT) Received: from [192.168.1.225] ([192.168.1.225]) by franklin.pc.umiacs.umd.edu with Microsoft SMTPSVC(6.0.3790.211); Fri, 4 Feb 2005 13:41:09 -0500 In-Reply-To: <15306.1107536905@sss.pgh.pa.us> References: <27afcdf4f7f6c6de86d93dc87d9bb6ec@umiacs.umd.edu> <15306.1107536905@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-admin@postgresql.org From: Gary Jackson Subject: Re: Downlevel database Date: Fri, 4 Feb 2005 13:41:14 -0500 To: Tom Lane X-Mailer: Apple Mail (2.619.2) X-OriginalArrivalTime: 04 Feb 2005 18:41:09.0902 (UTC) FILETIME=[182A72E0:01C50AE9] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/37 X-Sequence-Number: 16205 On Feb 4, 2005, at 12:08 PM, Tom Lane wrote: > > No, no, and no. A 7.2.anything server would flat out refuse to start > in > a 7.3.* database (because it checks PG_VERSION). You might have been > using 7.3 client-side code to talk to the 7.2 server, but that wouldn't > cause this sort of failure. > > A possible quick-and-dirty solution is "VACUUM pg_database" (issued > from > any of the databases that you can get into). If that doesn't work then > you've got serious problems :-( > > regards, tom lane > The 7.3 data directory was actually elsewhere -- duh on me. Thanks for the help! -- Gary Jackson bargle@umiacs.umd.edu