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