Re: ERROR: Cache lookup failed for relation 5741599 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: Cache lookup failed for relation 5741599
Date
Msg-id 24949.1058389138@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: Cache lookup failed for relation 5741599  (jerome <jerome@gmanmi.tv>)
Responses Re: ERROR: Cache lookup failed for relation 5741599  (jerome <jerome@gmanmi.tv>)
List pgsql-general
jerome <jerome@gmanmi.tv> writes:
>   i was running postgres in foreground while doing a vaccum.. the vaccum didnt
> finish its job because of a power failure...
>  i tried to reconnect to the db and i got this error when i issue a \d
>  (hoping  to see the tables..)
> ERROR:  Cache lookup failed for relation 5741599
> is there a way to retrieve my data..??

You might find that reindexing the system indexes will get you out of
trouble.  See the REINDEX man page for the detailed procedure to follow;
it's a bit messy...

            regards, tom lane

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?
Next
From: Lynna Landstreet
Date:
Subject: Anyone used pgHoster.com?