Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6404F2E0066 for ; Wed, 20 Feb 2008 16:22:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91273-04 for ; Wed, 20 Feb 2008 16:22:49 -0400 (AST) Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by postgresql.org (Postfix) with ESMTP id 0251C2E0050 for ; Wed, 20 Feb 2008 16:22:49 -0400 (AST) Received: from compute2.internal (compute2.internal [10.202.2.42]) by out1.messagingengine.com (Postfix) with ESMTP id 032009230F; Wed, 20 Feb 2008 15:22:49 -0500 (EST) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute2.internal (MEProxy); Wed, 20 Feb 2008 15:22:49 -0500 X-Sasl-enc: 6vnjVcQ6aMaL9A0qWeXcK/Bpz8aIWtlnuLLwYhpzEzZR 1203538968 Received: from [192.168.1.235] (76-191-150-176.dsl.dynamic.sonic.net [76.191.150.176]) by mail.messagingengine.com (Postfix) with ESMTPSA id 48A4B2AC65; Wed, 20 Feb 2008 15:22:48 -0500 (EST) Message-ID: <47BC8C15.1060805@fastmail.net> Date: Wed, 20 Feb 2008 12:22:45 -0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Power outage borked things (8.1.10)... References: <47BBF298.4010108@fastmail.net> <8625.1203523828@sss.pgh.pa.us> <47BC7C24.9040606@fastmail.net> <15060.1203536689@sss.pgh.pa.us> In-Reply-To: <15060.1203536689@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/234 X-Sequence-Number: 28308 Tom Lane wrote: > Darren Reed writes: > > # su postgres -c "/usr/pkg/bin/pg_resetxlog -f /data/db" > > Transaction log reset > > > PANIC: could not access status of transaction 4570963 > > DETAIL: could not read from file "pg_clog/0004" at offset 90112: > > Undefined error: 0 > > You may need to append a few pages of zeroes to pg_clog/0004 ... > So doing this: # dd if=/dev/zero bs=8192 count=1 | cat >> 0004 allowed the database to start, but tables are missing. I'll keep restoring. Thanks, Darren