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

From Tom Lane
Subject Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
Date
Msg-id 4057.1253109673@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: invalid page header in block 502758 of relation base/16388/16403  (fous velkej <honza801@gmail.com>)
List pgsql-bugs
fous velkej <honza801@gmail.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

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #5061: pg_autovacuum is not in 8.4 Version
Next
From: fous velkej
Date:
Subject: Re: ERROR: invalid page header in block 502758 of relation base/16388/16403