Re: ERROR: Cache lookup failed for relation 5741599

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: Cache lookup failed for relation 5741599
Дата
Msg-id 24949.1058389138@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: Cache lookup failed for relation 5741599  (jerome <jerome@gmanmi.tv>)
Ответы Re: ERROR: Cache lookup failed for relation 5741599  (jerome <jerome@gmanmi.tv>)
Список 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 по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: Postgresql "FIFO" Tables, How-To ?
Следующее
От: Lynna Landstreet
Дата:
Сообщение: Anyone used pgHoster.com?