there is a database running on xen dom U, but the node (dom0) went down,
we have a cluster, so the other node started the service and there is
nothing that shows any problem
unless i use SELECT on this database/table (this db contains only one table)
there is no backup of the database.
i can't see
fous velkej 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 context about
your p
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 i
fous velkej 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: i
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
fous velkej 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 is, that there a
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 sim
