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
