Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CA97B2E0032 for ; Wed, 20 Feb 2008 12:10:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 18828-01 for ; Wed, 20 Feb 2008 12:10:34 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6136F2E0044 for ; Wed, 20 Feb 2008 12:10:34 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1KGAS8L008626; Wed, 20 Feb 2008 11:10:29 -0500 (EST) To: Darren Reed cc: pgsql-admin@postgresql.org Subject: Re: Power outage borked things (8.1.10)... In-reply-to: <47BBF298.4010108@fastmail.net> References: <47BBF298.4010108@fastmail.net> Comments: In-reply-to Darren Reed message dated "Wed, 20 Feb 2008 01:27:52 -0800" Date: Wed, 20 Feb 2008 11:10:28 -0500 Message-ID: <8625.1203523828@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/231 X-Sequence-Number: 28305 Darren Reed writes: > Starting up postgres, I get the log contents below. > Is it really as bad as it suggests, namely that I > need to recover from backup? Probably :-( pg_resetxlog would let you into the database, but I do not have high hopes about the consistency/correctness of what you'll find. The best advice would be: 1. pg_resetxlog 2. pg_dumpall 3. initdb, restore from backup 4. compare dump from step 2 to backup dump, apply any changes that seem sane And don't forget 5. Figure out why a simple power failure was able to do this to you, and fix it. The most likely bet is that your disk drives are lying about write completion ... see the PG archives for discussion. regards, tom lane