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?
regards, fous
>
> Right, so it would be in the .3 file at block number 109542.
>
> regression=# select 502758 / 131072;
> ?column?
> ----------
> 3
> (1 row)
>
> regression=# select 502758 % 131072;
> ?column?
> ----------
> 109542
> (1 row)
>
>
> regards, tom lane
>