From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Witney <awitney@sgul.ac.uk>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: Michael Fuhr <mike@fuhr.org>
Subject: Re: pg_dump error... Follow up
Date: Thu, 08 Sep 2005 10:01:03 -0400
Message-ID: <6364.1126188063@sss.pgh.pa.us> (raw)
In-Reply-To: <BF45C3C9.4C82F%awitney@sgul.ac.uk>
References: <BF45C3C9.4C82F%awitney@sgul.ac.uk>
Adam Witney <awitney@sgul.ac.uk> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, awitney@sgul.ac.uk, mike@fuhr.org
Subject: Re: pg_dump error... Follow up
In-Reply-To: <6364.1126188063@sss.pgh.pa.us>
References: <BF45C3C9.4C82F%awitney@sgul.ac.uk> <6364.1126188063@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox