fous velkej <honza801(at)gmail(dot)com> writes:
> hi again
> i've stopped postgres and done this
> dd if=16403.3.orig of=16403.3 bs=8192 count=109541
> dd if=/dev/zero bs=8192 count=1 >> 16403.3
> dd if=16403.3.orig skip=109542 bs=8192 >> 16403.3
> then started postgres, but did not help, the same error appears.
> ERROR: invalid page header in block 502758 of relation base/16388/16403
> am i doing anything wrong?
You appear to be zeroing block 109541 not 109542.
regards, tom lane