t see any solution and if you can't see any solution either, i'm
going to reinit the db
:)
fous
2009/9/17 Tom Lane :
> fous velkej writes:
>> ok, so i did reindexing ending with following error
>> proxylog=# REINDEX TABLE user_record ;
>> ERROR: concurrent insert
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
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
i forgot the system informations
postgresql-server-8.4.0-1PGDG.rhel5
linux kernel 2.6.18-128.4.1.el5xen x86_64
centos release 5.3 (final)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
well, i knew how to fix it (probably the reindexing, that you mentioned;))
but i think this happens often in our database, so what informations would
you like to know?
i'm awaiting orders :)
fous
> Nope.
>
> If you just want to fix it, reindexing that index should do the trick.
>
> If you want
