Postgres Pro
Downloads
Home   >   mailing lists

locate DB corruption - Mailing list pgsql-general

From Dave Peticolas
Subject locate DB corruption
Date
Msg-id CAPRbp04SbFObUL1m_geh3U57bAHE3gy0Q1Zuc0B_bCcUtsG5VQ@mail.gmail.com
Whole thread Raw
Responses Re: locate DB corruption
List pgsql-general
Tree view
Hello, I'm running into the following error running a large query on a database restored from WAL replay:

could not access status of transaction 330569126
DETAIL: Could not open file "pg_clog/0C68": No such file or directory

Searches of this mailing list seem to indicate this means a database row has been corrupted. How would I go about locating the point of corruption in order to fix?

thanks,
dave

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Next
From: Adrian Klaver
Date:
Subject: Re: locate DB corruption