X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E932C11F6278 for ; Wed, 19 Apr 2006 20:42:06 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.126 X-Spam-Level: X-Spam-Status: No, score=0.126 required=5 tests=[AWL=0.126] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id TvwYR9kiA1NV for ; Wed, 19 Apr 2006 20:42:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2579611F625E for ; Wed, 19 Apr 2006 20:42:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3JNg1Cw005192; Wed, 19 Apr 2006 19:42:01 -0400 (EDT) To: "Thomas F. O'Connell" cc: pgsql-admin@postgresql.org Subject: Re: Invalid Page Headers In-reply-to: References: Comments: In-reply-to "Thomas F. O'Connell" message dated "Wed, 19 Apr 2006 22:31:14 -0000" Date: Wed, 19 Apr 2006 19:42:01 -0400 Message-ID: <5191.1145490121@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/193 X-Sequence-Number: 21362 "Thomas F. O'Connell" writes: > Any tips on turning "ERROR: invalid page header in block 34 of > relation" into a pg_filedump command that would yield something useful > or interesting? If so, I'll post the results of all three relations > known to be corrupt so far. For me, the nicest pg_filedump output format is "-i -f", but if the page is sufficiently hosed that pg_filedump can't make any sense of it, you may have to fall back to a raw dump, "-d". In any case, if you don't want to dump the entire file, use "-R blkno" or "-R startblk endblk" to constrain the dump. BTW, last I heard the posting size limit on these lists was only about 20K. If you don't want your results to languish awhile in the moderator's approval queue, you might want to post a link to the dump instead of the whole thing. regards, tom lane