pg_clog / pg_xlog corruption? - Mailing list pgsql-general

From Adam Haberlach
Subject pg_clog / pg_xlog corruption?
Date
Msg-id 20031021164926.A5980@newsnipple.com
Whole thread Raw
Responses Re: pg_clog / pg_xlog corruption?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: pg_clog / pg_xlog corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
    We had one of our databases suddenly try to reference a pg_clog
file that didn't exist whenever we attempted to select from a certain
table.  Anyone know of a way to recover from this?  Is there a way to
reset the transaction logs and just use whatever data is actually
stored in the system?

--
Adam Haberlach         |  "We spent the 90's all trying to figure out
adam@mediariffic.com   |  how to get email and the 00's trying to
http://mediariffic.com |  figure out how to not get email."
                       |             -- Joe Gross

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Proposed structure for coexisting major versions
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pg_clog / pg_xlog corruption?