Re: ERROR: invalid page header in block 502758 of relation base/16388/16403 - Mailing list pgsql-bugs

hi again

i've stopped postgres and done this
dd if=3D16403.3.orig of=3D16403.3 bs=3D8192 count=3D109541
dd if=3D/dev/zero bs=3D8192 count=3D1 >> 16403.3
dd if=3D16403.3.orig skip=3D109542 bs=3D8192 >> 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=3D# select 502758 / 131072;
> =A0?column?
> ----------
> =A0 =A0 =A0 =A03
> (1 row)
>
> regression=3D# select 502758 % 131072;
> =A0?column?
> ----------
> =A0 109542
> (1 row)
>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane
>