PostgreSQL 8.3 data corruption - Mailing list pgsql-general

From Chitra Creta
Subject PostgreSQL 8.3 data corruption
Date
Msg-id CABkVLeOnG_YGdJxEQ_Nnx3z=bQU84kBn8ikYY7+tLZ7g1yN+HQ@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 8.3 data corruption
List pgsql-general
Hi there,

I have mission-critical data running on PostgreSQL 8.3. My database got corrupted a few days ago as I ran out of disk space. 

I had to run pg_resetxlog to get the database started again. I am now experiencing the following errors:

1. ERROR: t_xmin is uncommitted in tuple to be updated

2. ERROR: could not access status of transaction 61323662
  Detail: Could not read from file "pg_subtrans/03A7" at offset 188416: No error.

Does anyone know how to resolve the issues above? Would a VACUUM FULL or a dump and restore work? Or is there another way to fix the above.


Thanking you in advance,
Chitra

pgsql-general by date:

Previous
From: "Matthew Churcher"
Date:
Subject: Re: Having trouble with pg_dumpall -o
Next
From: "Schade, Jeffrey"
Date:
Subject: Table / View Security Report