| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
| Cc: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Undetected corruption of table files |
| Date: | 2007-08-29 06:59:55 |
| Message-ID: | 82ejhmddw4.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
* Alban Hertroys:
> If you have a "proper" production database server, your memory has
> error checking, and your RAID controller has something of the kind
> as well.
To my knowledge, no readily available controller performs validation
on reads (not even for RAID-1 or RAID-10, where it would be pretty
straightforward).
Something like an Adler32 checksum (not a full CRC) on each page might
be helpful. However, what I'd really like to see is something that
catches missed writes, but this is very difficult to implement AFAICT.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-08-29 07:16:24 | Re: Seeking datacenter PITR backup suggestions |
| Previous Message | rafikoko | 2007-08-29 06:55:41 | pg_dump.... pg_restore...how long does it take? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yoshiyuki Asaba | 2007-08-29 07:38:06 | Re: initdb failed on Windows 2000 |
| Previous Message | Stefan Kaltenbrunner | 2007-08-29 06:13:33 | Re: reviving dead buildfarm animals |