X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 73DEDD1D27F for ; Fri, 5 Mar 2004 09:10:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26705-10 for ; Fri, 5 Mar 2004 05:10:31 -0400 (AST) Received: from mxc.pcnet.ro (unknown [82.137.14.2]) by svr1.postgresql.org (Postfix) with ESMTP id BDB40D1D179 for ; Fri, 5 Mar 2004 05:10:27 -0400 (AST) Received: from aldratech.com (aldratech.com.pcnet.ro [213.154.158.58] (may be forged)) by mxc.pcnet.ro (8.11.6/8.11.6) with ESMTP id i259AXY08295 for ; Fri, 5 Mar 2004 11:10:33 +0200 Received: from aldratech.com ([192.168.0.6]) by aldratech.com for with eXtremail; Fri, 5 Mar 2004 11:10:27 +2GMT Message-ID: <40484403.70001@aldratech.com> Date: Fri, 05 Mar 2004 11:10:27 +0200 From: Radu-Adrian Popescu Organization: Aldratech Ltd. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040124 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Silvana Di Martino Cc: pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) References: <200403050951.33230.silvanadimartino@tin.it> In-Reply-To: <200403050951.33230.silvanadimartino@tin.it> X-Enigmail-Version: 0.83.4.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/27 X-Sequence-Number: 12597 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Silvana Di Martino wrote: | The new italian law about personal data protection (aka "privacy") | requires the use of cryptography _both_ for protecting the network | traffic _and_ for protecting the (personal) data stored on the hard | disk. | | While I can see how to protect a PGSQL connection using SSH | tunneling or a VPN, I cannot see any way to encrypt a PGSQL | database stored on a hard disk, put aside the possibility to | encrypt the hosting file system with LoopAES. | | Is there any (native/third party) tool for encrypting a PGSQL | database on the disk? Is there any PGSQL option for encrypting data | on the fly? | | Many thanks in advance for your attention. | | NOTE: the italian law on privacy ("Decreto Legge 196/03", Dicembre | 2003) is available on the net: | | http://www.garanteprivacy.it http://www.interlex.it | | Of course, just in italian... | ----------------------------------------- Alessandro Bottoni and | Silvana Di Martino alessandrobottoni@interfree.it | silvanadimartino@tin.it | | ---------------------------(end of | broadcast)--------------------------- TIP 7: don't forget to | increase your free space map settings | | Are you sure you need to encrypt the _database_ ? It seems strange to require encryption of all the data, as you would get using LoopAES. I think you only need to decide (and probably the privacy protection law stipulates this) what data you need to encrypt and store that data encrypted in the database; such as customer's names, addresses, social data, payment data and so on. On the other hand, I think you should be doing this anyway. I know we are :-) Regards, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFASEQCVZmwYru5w6ERAqrSAJ0b2LPIe2TznFS4f4l9iYC3nMA9VgCgiKDs MMFfrReUhbvI5xXfG+Ha1PE= =X1ZW -----END PGP SIGNATURE-----