Re: Corrupted table - Mailing list pgsql-novice

From Tom Lane
Subject Re: Corrupted table
Date
Msg-id 20896.1002601391@sss.pgh.pa.us
Whole thread Raw
In response to Re: Corrupted table  (Robert Mosher <mosher@andrews.edu>)
Responses Re: Corrupted table  (Robert Mosher <mosher@andrews.edu>)
List pgsql-novice
Robert Mosher <mosher@andrews.edu> writes:
> So no suggestions to recover things, or at least only kill the one table,
> and not the entire database?

You should be able to drop the broken table after doing

    touch $PGDATA/base/yourdb/yourtable

(make the obvious substitutions...)  Your immediate problem is you
have a pg_class entry for a table and no underlying file to match.

            regards, tom lane

pgsql-novice by date:

Previous
From: Robert Mosher
Date:
Subject: Corrupted table . . .
Next
From: Robert Mosher
Date:
Subject: Re: Corrupted table