Re: Database corruption. - Mailing list pgsql-general

From Tom Lane
Subject Re: Database corruption.
Date
Msg-id 25510.1170955507@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database corruption.  (Michael Guerin <guerin@rentec.com>)
List pgsql-general
Michael Guerin <guerin@rentec.com> writes:
> You're suggesting to zero out the block in the underlying table files,
> or creating the missing pg_clog file and start filling with zero's?

The former.  Making up clog data is unlikely to help --- the bad xmin is
just the first symptom of what's probably more widespread corruption in
the table page.  If you want, once you've identified the page containing
the problem, use "pg_filedump -i -f" to dump out that page and we can
have a look to see just how bad it is.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Guerin
Date:
Subject: Re: Database corruption.
Next
From: "Brusser, Michael"
Date:
Subject: Re: Database corruption.