Data integrity and sanity check

From: Ferruccio Zamuner <nonsolosoft(at)diff(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Data integrity and sanity check
Date: 2002-03-26 09:11:57
Message-ID: 200203260911.g2Q9Bvt35198@tnt.diff.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Denis Gasparin 2002-03-26 10:06:48 Altering a CHAR(4) column CHAR(5) changing pg_attribute
Previous Message Dominique ROUSSEAU 2002-03-26 09:07:30 INSERTs slow