On 23/11/05 10:20 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
