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 > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
