Re: pg_dump error... Follow up - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump error... Follow up
Date
Msg-id 6364.1126188063@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump error... Follow up  (Adam Witney <awitney@sgul.ac.uk>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Adam Witney
Date:
Subject: Re: pg_dump error... Follow up
Next
From: Tom Lane
Date:
Subject: Re: pg_dump error... Follow up