Re: How to determine a database is intact? - Mailing list pgsql-general

From Greg Stark
Subject Re: How to determine a database is intact?
Date
Msg-id 87brgfuxqb.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: How to determine a database is intact?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> Believe it or not, we haven't gotten many requests for this feature,
> partly because such corruption is so rare.  Also, any checker isn't
> going to find a change from "Baker" to "Faker" in a text field.

Well there were people asking for per-block checksums. Given the frequency of
people complaining about hardware problems I'm starting to think they may be a
good idea after all.

But checksums don't detect corruption caused by software failure. That would
require a more of an fsck-like approach. There's nothing wrong with the idea,
but it would be a lot of work and nobody else has felt the need for it.

--
greg

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Text Search vs MYSQL vs Lucene
Next
From: pw
Date:
Subject: Where does postgres store records of DROP-ed columns?