Re: Database corruption? - Mailing list pgsql-general

From Tom Lane
Subject Re: Database corruption?
Date
Msg-id 20715.1004457793@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database corruption?  (Alvaro Herrera <alvherre@atentus.com>)
Responses Re: Database corruption?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
Alvaro Herrera <alvherre@atentus.com> writes:
> The problem ended up being bad RAM (it was good two weeks ago). I don't
> think it's of any use to do anything else with the database.

Ah so.  Thanks for following up.

It may be unthinkable hubris to say this, but ... I am starting to
notice that a larger and larger fraction of serious trouble reports
ultimately trace to hardware failures, not software bugs.  Seems we've
done a good job getting data-corruption bugs out of Postgres.

Perhaps we should reconsider the notion of keeping CRC checksums on
data pages.  Not sure what we could do to defend against bad RAM,
however.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Database corruption?
Next
From: "Jeff Lu"
Date:
Subject: Re: Differential Backups