Re: Data corruption zero a file - help!!

On Mon, Mar 06, 2006 at 05:17:54PM +1100, Noel Faux wrote:
> dd bs=8k skip=115860 count=1
> if=/usr/local/postgresql/postgresql-7.4.8/data/base/37958/111685332.68 |
> od -x

Wrong block (115860) -- you used the number from my earlier message,
which was based on the bad block being 902292. After noticing that
the error message said the bad block was 9022921 I corrected both
the file number and the block:

> >I suggested looking in the .6 file based on block 902292; if the
> >real bad block is 9022921 then I think it would be block 110025
> >in file .68 (again, check the math yourself).

Try skip=110025. You can use pg_filedump to examine the block in
an easier-to-read format; since you're running 7.4 you'd need
pg_filedump 3.0.

http://sources.redhat.com/rhdb/utilities.html

Try running this command:

pg_filedump -if -R 110024 110026 /path/111685332.68

That should show the bad block (110025) and the block before and
after it.

--
Michael Fuhr