Data integrity and sanity check

From: Ferruccio Zamuner <nonsolosoft(at)diff(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Data integrity and sanity check
Date: 2002-03-30 15:08:09
Message-ID: 200203301508.g2UF88e00989@tnt.diff.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

someone asks me about an utility to check any PostgreSQL database
data to be sure that:
1) there is not any page corrupted
(by a memory fault or a damaged disk)
2) re-check any constraint inserted into the database

I really don't know if PostgreSQL itself has any crc check on
its pages. Please, there is anyone able to confirm such function?

I've understood that PostgreSQL trust the operating system for
doing its work, but I don't know if there is any operating system
able to give warranty the memory sanity before allocation, during
the memory use.

According to me, if the database is well-designed it's not
possible to find constraint violation on data already inserted
and accepted from the SQL engine.
Am I in fault for this sentence?


Thank you in advance for any reply.

Best regards, \fer

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-03-30 15:34:31 Re: Data integrity and sanity check
Previous Message Jessica Perry Hekman 2002-03-30 13:43:32 Re: timeout implementation issues