From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Data corruption zero a file - help!! |
Date: | 2006-03-06 08:42:15 |
Message-ID: | 20060306084215.GA97118@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2006-03-06 09:52:27 | Re: query timeout |
Previous Message | Michael Trausch | 2006-03-06 08:40:25 | Syntax error, but where? |