Postgres Pro
Downloads
Home   >   mailing lists

Re: Corrupted Data? - Mailing list pgsql-general

From Chester Kustarz
Subject Re: Corrupted Data?
Date
Msg-id Pine.BSO.4.44.0409140042210.26903-100000@detroit.arbor.net
Whole thread Raw
In response to Corrupted Data?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: Corrupted Data?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: fabien@cyriacrea.net
Date:
Subject: Index inheritance
Next
From: "Jeffrey W. Baker"
Date:
Subject: psql exit status varies for scripts on STDIN