Re: [GENERAL] FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1

2009-07-25 Thread Tom Lane
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 --

Re: [GENERAL] FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1

2009-07-24 Thread Andrew Radamis
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

Re: [GENERAL] FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1

2009-07-24 Thread Tom Lane
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

[GENERAL] FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1

2009-07-24 Thread Andrew Radamis
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