X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 017C2D8724 for ; Thu, 8 Sep 2005 11:01:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04572-03 for ; Thu, 8 Sep 2005 14:01:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C40BDD86BB for ; Thu, 8 Sep 2005 11:01:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j88E1473006365; Thu, 8 Sep 2005 10:01:04 -0400 (EDT) To: Adam Witney Cc: pgsql-admin , Michael Fuhr Subject: Re: pg_dump error... Follow up In-reply-to: References: Comments: In-reply-to Adam Witney message dated "Thu, 08 Sep 2005 10:32:41 +0100" Date: Thu, 08 Sep 2005 10:01:03 -0400 Message-ID: <6364.1126188063@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/78 X-Sequence-Number: 18815 Adam Witney writes: > Unfortunately the pg_filedump you requested gives an error: > Error: Premature end of file encountered. > (there is a .1 file also for this table, do I have to stick the two together > or something?) Yeah. Each file contains 131072 pages, so the correct place to look is 165390-131072 in the .1 file, ie pg_filedump -R 34318 34320 134401986.1 (I need to look at the pg_filedump code, too, because it seems like it ought to be able to do that for itself...) regards, tom lane