Re: pg_dump error... Follow up

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Michael Fuhr <mike(at)fuhr(dot)org>
Subject: Re: pg_dump error... Follow up
Date: 2005-09-08 14:01:03
Message-ID: 6364.1126188063@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Adam Witney <awitney(at)sgul(dot)ac(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-09-08 14:22:58 Re: pg_dump error... Follow up
Previous Message Adam Witney 2005-09-08 13:50:29 Re: pg_dump error... Follow up