Re: Database Corruption - last chance recovery options? - Mailing list pgsql-general

From Thomas F. O'Connell
Subject Re: Database Corruption - last chance recovery options?
Date
Msg-id 51D68093-AB8C-4B7D-ABA4-10257F585E52@o.ptimized.com
Whole thread Raw
In response to Database Corruption - last chance recovery options?  (Michael Best <mbest@pendragon.org>)
Responses Re: Database Corruption - last chance recovery options?  (Michael Best <mbest@pendragon.org>)
List pgsql-general
On Jan 4, 2007, at 11:24 PM, Michael Best wrote:

> When I finally got the error report in the morning the database was
> in this state:
>
> $ psql dbname
>
> dbname=# \dt
> ERROR:  cache lookup failed for relation 20884

Do you have your error logs, and were there any relevant errors in
them preceding your inability to get a table listing via psql?

--
Thomas F. O'Connell

optimizing modern web applications
: for search engines, for usability, and for performance :

http://o.ptimized.com/
615-260-0005

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Continue sequence
Next
From: Andrew Chernow
Date:
Subject: Re: Database versus filesystem for storing images