Jesper Krogh <jesper@xxxxxxxx> writes: > On 2011-10-09 17:41, Tom Lane wrote: >> The traditional solution is to zero out the bad block, eg using dd from >> /dev/zero. It's easy to zero more than you intended, so practicing on a >> scratch copy of the table is recommended. > So it is "just" blocknumber * blocksize .. offset, blocksize of zeroes.. ? > Or is the math harder? You have to account for the division of the table into segment files; if blocknumber * blocksize is greater than 1GB, reduce modulo 1GB and look to the appropriate "xxx.n" segment file. Otherwise it's what you'd expect. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
