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 1490AD1D14B for ; Fri, 5 Mar 2004 08:53:13 +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 26802-04 for ; Fri, 5 Mar 2004 04:53:05 -0400 (AST) Received: from vsmtp4.tin.it (unknown [212.216.176.150]) by svr1.postgresql.org (Postfix) with ESMTP id 37684D1CC97 for ; Fri, 5 Mar 2004 04:53:03 -0400 (AST) Received: from host247-33.pool8248.interbusiness.it (82.48.33.247) by vsmtp4.tin.it (7.0.019) (authenticated as silvanadimartino) id 402CD2F000418967 for pgsql-admin@postgresql.org; Fri, 5 Mar 2004 09:53:00 +0100 From: Silvana Di Martino To: pgsql-admin@postgresql.org Subject: Database Encryption (now required by law in Italy) Date: Fri, 5 Mar 2004 09:54:25 +0000 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200403050951.33230.silvanadimartino@tin.it> Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/26 X-Sequence-Number: 12596 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