X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EDFBDD82EE for ; Thu, 13 Oct 2005 13:31:19 -0300 (ADT) 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 47380-02 for ; Thu, 13 Oct 2005 16:31:17 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 64651D82CF for ; Thu, 13 Oct 2005 13:31:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9DGVHel023172 for ; Thu, 13 Oct 2005 12:31:17 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Urgent! In-reply-to: <200510131556.j9DFumT03567@candle.pha.pa.us> References: <200510131556.j9DFumT03567@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Thu, 13 Oct 2005 11:56:48 -0400" Date: Thu, 13 Oct 2005 12:31:17 -0400 Message-ID: <23171.1129221077@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/153 X-Sequence-Number: 19225 Bruce Momjian writes: >> You should never just turn off a database server... always shut it down >> normally... Turning it off was a major mistake. > PostgreSQL should never get corrupted by turning off the server. It > isn't ideal to do that, but it should not get corrupted. We can only make that promise if we are on hardware that doesn't lie to us about disk write completion ... if this machine is generic PC hardware it's probably not configured properly. The symptoms sound to me like corrupt data (probably due to a partial page disk write). There isn't going to be any magic fix, but you can probably recover everything but the specific damaged page(s). See the mailing list archives for previous discussions of cleaning up data corruption. regards, tom lane