pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (13+ messages)  latest in thread

Message-ID: <6364.1126188063@sss.pgh.pa.us>
Permalink:  ../6364.1126188063@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6364.1126188063@sss.pgh.pa.us

 · 

reply

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