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 B8FD5D1D104 for ; Fri, 5 Mar 2004 11:22:33 +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 77210-01 for ; Fri, 5 Mar 2004 07:22:30 -0400 (AST) Received: from Phobos.turbocorp.com (unknown [198.212.166.46]) by svr1.postgresql.org (Postfix) with ESMTP id 523AFD1CA50 for ; Fri, 5 Mar 2004 07:22:27 -0400 (AST) Received: from turbocorp.com (localhost [127.0.0.1]) by Phobos.turbocorp.com (8.11.6/8.11.6) with ESMTP id i25BMTD20826 for ; Fri, 5 Mar 2004 06:22:29 -0500 Message-ID: <404862F5.7030804@turbocorp.com> Date: Fri, 05 Mar 2004 06:22:29 -0500 From: Sergio Chaves Reply-To: sergio@turbocorp.com Organization: Turbo Logistics, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) References: <200403050951.33230.silvanadimartino@tin.it> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/32 X-Sequence-Number: 12602 Hi. That is an article on www.linuxuser.co.uk , issue 34 entitled "A Guide to filesystem encryption" that may do what you want to do. It uses a method called "Loop-AES" http://loop-aes.sourceforge.net . Hope it works for you Sergio 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 > > > -- °v° Sergio Chaves °v° /(_)\ www.turbocorp.com /(_)\ ^ ^ Enhanced Solutions Computing ^ ^ 770.532.2239 Linux User #221305