Re: "invalid page header in block 597621 of relation..."error - Mailing list pgsql-general

From Tom Lane
Subject Re: "invalid page header in block 597621 of relation..."error
Date
Msg-id 14413.1132850539@sss.pgh.pa.us
Whole thread Raw
In response to Re: "invalid page header in block 597621 of relation..."error  (Adam Witney <awitney@sgul.ac.uk>)
Responses Re: "invalid page header in block 597621 of relation..."error  (Adam Witney <awitney@sgul.ac.uk>)
List pgsql-general
Adam Witney <awitney@sgul.ac.uk> writes:
> On 24/11/05 4:19 pm, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> The question is, can you tell whether any data is actually missing?

> Well each of these datasets are about 20,000 rows each... So I can tell
> which one is in (640792,12) and in (640799,1), they have the same dataset id
> value. Im assuming the missing ones in the middle will therefore be from the
> same dataset as well then... So I know which files did not get uploaded
> properly and I can re-upload them....

But can you tell whether there *were* any in the middle?  It might be
worth counting the rows currently present for that dataset, then
reloading and counting again.

            regards, tom lane

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Private email requests
Next
From: Adam Witney
Date:
Subject: Re: "invalid page header in block 597621 of relation..."error