Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_index_indrelid_index error, any ideas ?? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_index_indrelid_index error, any ideas ??
Date
Msg-id 14515.1127314514@sss.pgh.pa.us
Whole thread Raw
In response to pg_index_indrelid_index error, any ideas ??  (aw_contact@inbox.ru)
List pgsql-general
Tree view 
aw_contact@inbox.ru writes:
> I've got an error from postgresql server -
> "ERROR:  root page 1 of "pg_index_indrelid_index" has level 512, expected 0"
> This error appears on every command and i can't do anything with my
> database. Is it possible to solve this problem ?

See REINDEX.  Also you ought to run some memory and disk diagnostics
--- it looks like some part of your hardware dropped a bit.

            regards, tom lane

pgsql-general by date:

Previous
From: "Belinda M. Giardine"
Date:
Subject: Re: running vacuum in scripts
Next
From: Tom Lane
Date:
Subject: Re: Problems with leftover types in pg_temp schemas