Re: ERROR: Cache lookup failed for relation 5741599
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
Import Notes
Reply to msg id not found: 200307170528.58455.jerome@gmanmi.tvReference msg id not found: 200307170528.58455.jerome@gmanmi.tv
i tried running postgres and did a reindex..
and i got this..
...................
NOTICE: relation 16596 was reindexed
NOTICE: relation 16598 was reindexed
NOTICE: relation 16384 was reindexed
NOTICE: relation 16386 was reindexed
NOTICE: relation 1262 was reindexed
ERROR: Cannot create unique index. Table contains non-unique values
backend>
is there other ways of doing fixing this?
TIA
Show quoted text
On Thursday 17 July 2003 04:58, you wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?