Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2ACC09FA2A1 for ; Tue, 6 Feb 2007 07:15:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 62371-08 for ; Tue, 6 Feb 2007 07:15:39 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D1EDE9FA22A for ; Tue, 6 Feb 2007 07:15:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l16BFckV002217 for ; Tue, 6 Feb 2007 07:15:38 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l16AwXFv098656 for pgsql-admin@postgresql.org; Tue, 6 Feb 2007 06:58:33 -0400 (AST) (envelope-from news) From: "David Martin" X-Newsgroups: pgsql.admin Subject: FATAL 2: invalid checksum in control file Date: 6 Feb 2007 02:58:17 -0800 Organization: http://groups.google.com Lines: 19 Message-ID: <1170759497.250280.208050@s48g2000cws.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: s48g2000cws.googlegroups.com; posting-host=134.36.64.141; posting-account=JbmWFg0AAADC5sW5bbTVvyJt7lf6KzYC To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/94 X-Sequence-Number: 24559 I am trying to restore a database from a machine which has died. The machine was taken down normally but refused to restart so the data has been copied elsewhere. The database is in version 7.2 so I installed 7.2.8, but upon pointing the postmaster at the relevant data directory I get the error in the subject line. The databse was originally on a ReiserFS partition and is now on GPFS, if that makes any difference. Any cunning tips on how I can get the database back? I have exhausted my limited technical knowledge. (Yes I know a backup would ahve been a good idea, however, lets move on from where we are , not where we might have liked to have been). ..d