Re: clarifying a few error messages

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Thomas F.O'Connell" <tfo@monsterlabs.com>
Cc: pgsql-general@postgresql.org
Date: 2003-01-13T22:30:12Z
Lists: pgsql-general
"Thomas F.O'Connell" <tfo@monsterlabs.com> writes:
> As for the bad data on disk, I've got a backup, but how severe are we 
> talking? By not trusting it, do you mean that it could be flagrantly 
> wrong (i.e., truly corrupted; bad data), or just out of sync with 
> whatever writes were last occurring?

The high clog numbers you were quoting suggest completely-trashed
transaction ID fields (I'm assuming that the files actually present in
pg_clog have numbers nowhere near that).  I've only seen that happen in
the context of completely-trashed disk pages.  You could possibly do
some investigation for yourself using pg_filedump.

			regards, tom lane