Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6AF879FB2B9 for ; Tue, 6 Feb 2007 22:18:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 04573-07 for ; Tue, 6 Feb 2007 22:18:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ECBA99FB27E for ; Tue, 6 Feb 2007 22:18:38 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l172Iaqi027126; Tue, 6 Feb 2007 21:18:36 -0500 (EST) To: "David Martin" cc: pgsql-admin@postgresql.org Subject: Re: FATAL 2: invalid checksum in control file In-reply-to: <1170759497.250280.208050@s48g2000cws.googlegroups.com> References: <1170759497.250280.208050@s48g2000cws.googlegroups.com> Comments: In-reply-to "David Martin" message dated "06 Feb 2007 02:58:17 -0800" Date: Tue, 06 Feb 2007 21:18:36 -0500 Message-ID: <27125.1170814716@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/96 X-Sequence-Number: 24561 "David Martin" writes: > 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. Lessee ... 7.2 had pg_controldata and pg_resetxlog, so you have some hope. Try the former and see if it can extract anything. Then try the latter. Definitely RTFM on pg_resetxlog before using it. Also: is the "elsewhere" the same machine architecture as the original server? Do not even think about trying to recover x86 files on x86_64, for example. regards, tom lane