Re: ERROR: Cache lookup failed for relation 5741599

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jerome(at)gmanmi(dot)tv
Cc: PostgresGeneral <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: Cache lookup failed for relation 5741599
Date: 2003-07-16 20:58:58
Message-ID: 24949.1058389138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

jerome <jerome(at)gmanmi(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-16 21:10:02 Re: COPY problem
Previous Message Dmitry Tkach 2003-07-16 20:58:02 Re: Postgresql "FIFO" Tables, How-To ?