Andrew Radamis writes:
> ERROR: invalid page header in block 43 of relation "pg_attribute"
At this point I think you should assume you've got serious hardware
problems. Get hold of some memory and disk test programs and see what
you can find out.
regards, tom lane
--
Hi Tom,
Thanks for the reply! The reindex command you provided did not work, it gave
the same error as the one I got when logging in earlier, however I was
feeling reckless so I did reindex database ; and that completed
as follows:
NOTICE: table "pg_class" was reindexed
NOTICE: table "sql_featu
Andrew Radamis writes:
> I'm getting this error when I try to log into my database.
> *FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1
You've got a corrupted index. You can probably fix it like this:
export PGOPTIONS="-P"
psql ..usual options..
reindex
Hello,
I'm pretty new to pgsql, so speak slowly and draw plenty of pictures please
:P
I'm getting this error when I try to log into my database.
*FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1
*I've done some googleing and I found one mailing list item in another
language, a