Disk corruption detection

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Disk corruption detection
Date: 2006-06-11 17:42:55
Message-ID: 874pyrwpuo.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We recently had a partially failed disk in a RAID-1 configuration
which did not perform a write operation as requested. Consequently,
the mirrored disks had different contents, and the file which
contained the block switched randomly between two copies, depending on
which disk had been read. (In theory, it is possible to read always
from both disks, but this is not what RAID-1 configurations normally
do.)

Anyway, how would be the chances for PostgreSQL to detect such a
corruption on a heap or index data file? It's typically hard to
detect this at the application level, so I don't expect wonders. I'm
just curious if using PostgreSQL would have helped to catch this
sooner.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2006-06-11 18:15:40 Re: Fabian Pascal and RDBMS deficiencies in fully
Previous Message John Sidney-Woollett 2006-06-11 17:40:14 Ever increasing OIDs - gonna run out soon?