X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 71024535EB for ; Sat, 16 Apr 2005 13:38:03 -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 46024-01 for ; Sat, 16 Apr 2005 16:37:30 +0000 (GMT) Received: from lakermmtao02.cox.net (lakermmtao02.cox.net [68.230.240.37]) by svr1.postgresql.org (Postfix) with ESMTP id F2BDB5349D for ; Sat, 16 Apr 2005 13:37:29 -0300 (ADT) Received: from [192.168.1.2] (really [68.14.103.120]) by lakermmtao02.cox.net (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP id <20050416163727.VIEL6521.lakermmtao02.cox.net@[192.168.1.2]>; Sat, 16 Apr 2005 12:37:27 -0400 Subject: Re: database corruption From: Amadeus Zilfinski To: Ian Westmacott Cc: Chris Travers , pgsql-admin@postgresql.org In-Reply-To: <000b01c54235$e34e8140$76d81e42@hsd1.ma.comcast.net> References: <000b01c54235$e34e8140$76d81e42@hsd1.ma.comcast.net> Content-Type: text/plain Date: Sat, 16 Apr 2005 11:37:28 -0500 Message-Id: <1113669448.6483.4.camel@fileserver01.batrender> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/216 X-Sequence-Number: 17229 ,snipped. > - SuSE 9.1 > - 2.6.6 kernel > - Postgres 7.4.2 > - 300 TPS against DB containing 5-50GB data, no more than a dozen > concurrent connections. > - fsync (or not) and fdatasync I remember a problem that was fixed in the 2.6.9 kernel concerning XFS corruption (shutdowns I think were the worst). Also introduced some JFS stuff, but I don't run JFS so I didn't really pay much attention to that. Can you try a later (the latest?) vanilla kernel? AmadeusZ.-