Re: Database Corruption - last chance recovery options?

From: "Thomas F(dot) O'Connell" <tf(at)o(dot)ptimized(dot)com>
To: Michael Best <mbest(at)pendragon(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database Corruption - last chance recovery options?
Date: 2007-01-06 00:09:22
Message-ID: 51D68093-AB8C-4B7D-ABA4-10257F585E52@o.ptimized.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pakt sardines 2007-01-06 00:14:42 Advice needed on using postgres in commercial product
Previous Message Jorge Godoy 2007-01-06 00:02:00 Re: Database versus filesystem for storing images