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
fous velkej honza...@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.
ok, fault on my side
this is maybe better code
dd if=16403.3.orig of=16403.3 bs=8192 count=109542
dd if=/dev/zero bs=8192 count=1 16403.3
dd if=16403.3.orig skip=109543 bs=8192 16403.3
but now, it says
ERROR: index day contains unexpected zero page at block 502758
HINT: Please REINDEX it.
fous velkej honza...@gmail.com writes:
ok, so i did reindexing ending with following error
proxylog=# REINDEX TABLE user_record ;
ERROR: concurrent insert in progress
So that page header wasn't the only corrupted data in your database.
Maybe you'd better take a step back and tell us some
hi,
i got following error while selecting from my db
ERROR: invalid page header in block 502758 of relation base/16388/16403
i've found some solution in this thread
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
but my problem is, that there are multiple files with
fous velkej honza...@gmail.com writes:
i got following error while selecting from my db
ERROR: invalid page header in block 502758 of relation base/16388/16403
i've found some solution in this thread
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
but my problem