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

Adam Witney <awitney@sgul.ac.uk> 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.

            regards, tom lane