Re: Corrupted Data?

On Tue, 2004-09-14 at 00:46, Chester Kustarz wrote:
> On Mon, 13 Sep 2004, Matthew T. O'Connor wrote:
> > I backed up the entire data directory, and did a pg_resetxlog, but that
> > didn't help.  I found the specific row that seems to be the problem, but
> > I can't delete it.
>
> I have used TRUNCATE on the table in this situation to recover. Another
> option might be to DROP the table. Or perhaps restore from backups.

I would really prefer not to do that as pg_dump has apparently been
failing for a while so I would lose a fair amount of data.