X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C8FD1D1E156 for ; Thu, 19 Feb 2004 13:09:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48650-01 for ; Thu, 19 Feb 2004 09:09:31 -0400 (AST) Received: from kalcyt.ists.pwr.wroc.pl (Kalcyt.ists.pwr.wroc.pl [156.17.130.9]) by svr1.postgresql.org (Postfix) with SMTP id 11C24D1E166 for ; Thu, 19 Feb 2004 09:09:21 -0400 (AST) Received: (qmail 29622 invoked from network); 19 Feb 2004 13:09:18 -0000 Received: from unknown (HELO lukasz) (lpiskorz@81.210.119.225) by kalcyt.ists.pwr.wroc.pl with SMTP; 19 Feb 2004 13:09:18 -0000 Message-ID: <003701c3f6ea$33909780$0400a8c0@vivid.pl> From: "Lukasz Piskorz" To: Subject: Help - postgresql 7.0 and cannot read block 7959 of pg_log Date: Thu, 19 Feb 2004 14:13:42 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/279 X-Sequence-Number: 12453 Hello, I need very fast help. When I worked in postgresql 7.0 I saw message: database=>NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. The connection to the server was lost. Attempting reset: Succeeded. When I check all tables only one (very important in my database) is corrupted: database=>select * from table; ERROR: cannot read block 7959 of pg_log: Success Could you help me? What can I do? Can I remove this table and restore from backup? What do you think about software http://svana.org/kleptog/pgsql/pgfsck.html ? Best, Lukas