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 5A06DD813A for ; Thu, 13 Oct 2005 13:21:29 -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 44575-04 for ; Thu, 13 Oct 2005 16:21:24 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id DBF48D80B4 for ; Thu, 13 Oct 2005 13:21:24 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 13 Oct 2005 11:21:24 -0500 Subject: Re: Urgent! From: Scott Marlowe To: Bruce Momjian Cc: codeWarrior , pgsql-admin@postgresql.org In-Reply-To: <200510131556.j9DFumT03567@candle.pha.pa.us> References: <200510131556.j9DFumT03567@candle.pha.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1129220484.29961.191.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 13 Oct 2005 11:21:24 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200510/151 X-Sequence-Number: 19223 On Thu, 2005-10-13 at 10:56, Bruce Momjian wrote: > codeWarrior wrote: > > Lookas as if you've managed to turn off your computer mid-transaction > > thereby corrupting the postgreSQL commit logs (pg_clog)... > > > > You should never just turn off a database server... always shut it down > > normally... Turning it off was a major mistake. I dont know if you can > > recover or not as the system (postgreSQL) now thinks it is in the middle of > > a transaction... > > PostgreSQL should never get corrupted by turning off the server. It > isn't ideal to do that, but it should not get corrupted. Unless it is installed on hardware that lies about fsync. Which almost all ATA drives, parallel and serial, do, sadly.