Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 63AF29F939F for ; Tue, 2 Jan 2007 16:11:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 40972-07 for ; Tue, 2 Jan 2007 16:11:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id C294D9F938C for ; Tue, 2 Jan 2007 16:11:36 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 2 Jan 2007 20:11:32 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 02 Jan 2007 14:11:32 -0600 Subject: Re: Invalid page header in block 211 of relation From: Scott Marlowe To: ashok@kalculate.com Cc: pgsql-admin@postgresql.org In-Reply-To: <380-2200712212446327@M2W041.mail2web.com> References: <380-2200712212446327@M2W041.mail2web.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1167768692.29707.30.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 02 Jan 2007 14:11:32 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/5 X-Sequence-Number: 24161 On Tue, 2007-01-02 at 06:04, ashok@kalculate.com wrote: > Hi List, > > I'm using postgresql 7.4 on FC4 linux. > i have one table named "purchase". it is working fine since 10 months but > suddenly from 3-4 days it creates problem. > when i'm fire a simple "select * from purchase" query on psql prompt,it > gives following error: > > Invalid page header in block 211 of relation "purchase". > > i cannot understand what is the problem, why it is giving this error. > plz. help me. This is a serious problem. Most of the time you see this it can be blamed on broken hardware, although on rare occasions a pgsql bug might be causing it. There are several things you can do, and they kind of depend on the answer to the question "How important are the data in your database?" Can you take this machine out of production to test it? I'd recommend a good memory tester and to check your drives for possible errors. Has this machine crashed or had the power plug pulled lately? If so, it might be a problem with IDE hard drives and fsyncing. Lastly, got a backup?