Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C890D9FB434 for ; Fri, 13 Oct 2006 06:31:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 77244-04 for ; Fri, 13 Oct 2006 09:31:41 +0000 (UTC) X-Greylist: delayed 00:06:40.577227 by SQLgrey- Received: from dns.ricordatasystem.int (host10-241-static.73-81-b.business.telecomitalia.it [81.73.241.10]) by postgresql.org (Postfix) with SMTP id 746AD9FB433 for ; Fri, 13 Oct 2006 06:31:39 -0300 (ADT) Received: (qmail 23405 invoked by uid 1013); 13 Oct 2006 10:04:17 -0000 Received: from unknown (HELO mypc.ricordatasystem.info) (192.168.2.50) by dns.ricordatasystem.int with SMTP; 13 Oct 2006 10:04:17 -0000 Date: Fri, 13 Oct 2006 11:29:29 +0200 From: Enrico To: pgsql-admin@postgresql.org Subject: Disaster recovery: pg_class Message-ID: <20061013112929.1cbb7b9e@mypc.ricordatasystem.info> X-Mailer: Sylpheed-Claws 1.0.4 (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/88 X-Sequence-Number: 23391 After a system crash, I have this error: SELECT * from mytable; WARNING: could not write block 14 of 1663/1743558/1259 DETAIL: Multiple failures --- write error may be permanent. ERROR: xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0 CONTEXT: writing block 14 of relation 1663/1743558/1 I searched for 1259 oid, and I found that 1259 links to pg_class table. Is there any way to restore my pg_class table? Thanks in advantage. Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!! scotty@linuxtime.it - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi