Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 23/11/05 10:20 pm, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote:

> Adam Witney <awitney@xxxxxxxxxx> writes:
>> Whats the best way to zero the bad block?
> 
> Probably dd from /dev/zero, along the lines of
> 
> dd bs=8k seek=597621 count=1 conv=notrunc if=/dev/zero of=relation
> 
> (check this before you apply it ;-)).  You probably should stop the
> postmaster while doing this, in case it has a cached copy of the page.

Just wanted to clarify, should this not be

dd bs=8k seek=73333 count=1 conv=notrunc if=/dev/zero of=134401991.4

I thought that the 597621 blocks were split up over the . .1 .2 .3 .4 files?

Thanks again

Adam


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux