Re: "invalid page header in block 597621 of relation..."error

On 24/11/05 2:48 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>> Just wanted to clarify, should this not be
>> dd bs=8k seek=73333 count=1 conv=notrunc if=/dev/zero of=134401991.4
>
> Looks reasonable.
>
> regards, tom lane

Excellent thanks. I have run it and copied the changed file back into the
right place and run vacuum:

bugasbase2=# vacuum;
WARNING: relation "mba_data_base" page 597621 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640793 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640794 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640795 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640796 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640797 is uninitialized --- fixing
WARNING: relation "mba_data_base" page 640798 is uninitialized --- fixing
VACUUM

Does this look reasonable? Or should I be looking for other problems? There
are some different pages being fixed here from the ones that were shown
before (597621), they all belong to a different dataset so looks like I have
to reupload that one as well.

Thanks again for your help

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.