Re: RFC: CRC datatype - Mailing list pgsql-hackers

From ncm@zembu.com (Nathan Myers)
Subject Re: RFC: CRC datatype
Date
Msg-id 20001212123419.G30335@store.zembu.com
Whole thread Raw
In response to Re: RFC: CRC datatype  ("Horst Herb" <hherb@malleenet.net.au>)
Responses Re: RFC: CRC datatype  (Horst Herb <hherb@malleenet.net.au>)
List pgsql-hackers
On Sat, Dec 09, 2000 at 12:03:52AM +1100, Horst Herb wrote:
> AFAIK the thread for "built in" crcs referred only to CRCs in
> the transaction log. 

We have been discussing checksums for both the table blocks and for
the transaction log.

> Always remember that a psotgres data base on the harddisk can be
> manipulated accidentally / maliciously without postgres even running.
> These are the cases where you need row level CRCs.

"There is no security without physical security."  If somebody can
change the row contents, they can also change the row and/or block 
checksum to match.

Nathan Myers
ncm@zembu.com


pgsql-hackers by date:

Previous
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: CRC was: Re: beta testing version
Next
From: Tom Lane
Date:
Subject: Re: SourceForge & Postgres