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 5298D8B9B33 for ; Fri, 4 Feb 2005 16:48:32 +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 28192-03 for ; Fri, 4 Feb 2005 16:48:13 +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 B57948B9F36 for ; Fri, 4 Feb 2005 16:48:12 +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 11:47:55 -0500 Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <27afcdf4f7f6c6de86d93dc87d9bb6ec@umiacs.umd.edu> Content-Transfer-Encoding: 7bit From: Gary Jackson Subject: Downlevel database Date: Fri, 4 Feb 2005 11:48:00 -0500 To: pgsql-admin@postgresql.org X-Mailer: Apple Mail (2.619.2) X-OriginalArrivalTime: 04 Feb 2005 16:47:55.0347 (UTC) FILETIME=[464BA230:01C50AD9] 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/34 X-Sequence-Number: 16202 We have a problem with a PosgreSQL database where the user cannot get to their tables any more. I am not the primary administrator of this host (who is on vacation), nor am I the user of this database. The /var/log/posgresql file has entries like the following, at the end: FATAL 1: Database "trees_rock" does not exist in the system catalog. The current running version of the database is 7.2.2, and I suspect the database was created and maintained with 7.3.4 (after examining the bash history file for user postgres). Would running downlevel software cause this problem? Does this seem likely or possible? Now that the old database software is running on the new data, what do I do to recover? -- Gary Jackson bargle@umiacs.umd.edu