X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B1E1AD1B4F1 for ; Fri, 26 Sep 2003 00:28:03 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 87184-04 for ; Thu, 25 Sep 2003 21:27:56 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id CB838D1B52D for ; Thu, 25 Sep 2003 21:27:52 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h8Q0Rt6c005817; Thu, 25 Sep 2003 20:27:56 -0400 (EDT) To: Hornyak Laszlo Cc: pgsql-admin@postgresql.org Subject: Re: invalid page header In-reply-to: References: Comments: In-reply-to Hornyak Laszlo message dated "Thu, 25 Sep 2003 21:01:26 +0200" Date: Thu, 25 Sep 2003 20:27:55 -0400 Message-ID: <5816.1064536075@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/424 X-Sequence-Number: 10512 Hornyak Laszlo writes: > I have a problem again, now with PostgreSQL 7.3.4. One of my 1.8 million > rows tables have damaged, it operated all the day and now it is off, we > don`t know the reason. When we try to dump or select from it, it says > 'Invalid page header in block 12345 in prep'. > Does anybody know how to make our table healthy again? You could zero out that page (while the postmaster is stopped, preferably) but you ought to first try to figure out what data you are going to lose. Dumping the page with pg_filedump might provide some clues. See this thread for a recent exercise in file-dumping: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=20030922162322.E12708%40quartz.newn.cam.ac.uk&rnum=8&prev=/groups%3Fq%3Dpg_filedump%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3D20030922162322.E12708%2540quartz.newn.cam.ac.uk%26rnum%3D8 Or you could just use dd; since the page header is corrupt, it's unlikely that pg_filedump will be able to give you anything smarter than a bare hex/ascii dump (-d mode), which dd and od could do as well. regards, tom lane