On Thu, Apr 8, 2010 at 7:12 AM, Utsav Turray <utsav.turray@xxxxxxxxxxxx> wrote: > Even if If i try to pad the file 25205.3 using DD command I am not able to > calculate the bytes to be padded as the total count of the blocks is comming > out to be 521228 and the error is coming cannot read the 348938 block. Assuming 25205 is the right file for this table then block 348938 would be in 25205.2 and be bytes 694,352kB - 694,360kB. try dd if=25205.2 of=/tmp/data bs=8192 skip=$(( 348938 - 2 * 128 * 1024)) count=1 see if you get the same error. If you do and you're happy to zero out the bad block, deleting any data on it you could do something like: dd if=/dev/zero of=25205.2 bs=8192 seek=$(( 348938 - 2 * 128 * 1024)) count=1 -- greg -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
