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 41A7AD1D8AA for ; Fri, 5 Mar 2004 19:28: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 38150-10 for ; Fri, 5 Mar 2004 15:28:34 -0400 (AST) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by svr1.postgresql.org (Postfix) with ESMTP id DD64ED1D5D9 for ; Fri, 5 Mar 2004 15:28:32 -0400 (AST) Received: from host91-33.pool8248.interbusiness.it (82.48.33.91) by vsmtp3.tin.it (7.0.019) (authenticated as silvanadimartino) id 402CD18F0041E707; Fri, 5 Mar 2004 20:28:28 +0100 From: Silvana Di Martino To: Alex Page , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Date: Fri, 5 Mar 2004 20:24:38 +0000 User-Agent: KMail/1.5 References: <200403050951.33230.silvanadimartino@tin.it> <40488640.1040409@spacemonkeylabs.com> <20040305151154.GC11311@halcyon.ox.icnet.uk> In-Reply-To: <20040305151154.GC11311@halcyon.ox.icnet.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403052024.38291.silvanadimartino@tin.it> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/60 X-Sequence-Number: 12630 Alle 15:11, venerd=EC 5 marzo 2004, Alex Page ha scritto: > If you're trying to protect against somebody taking down your server > room door with a sledgehammer, lifting your server out of the rack, > driving it away and booting off an alternative medium to avoid needing > to know your root password, then a loopback encrypted partition (or data > encrypted in GPG where the decryption key is not stored on the database > server) is a sensible precaution. Unfortunately, the new Italian law forces us to take seriously into account= =20 this catastrophic scenario and another one that is almost as worring: an=20 unfaithful SysAdmin that copies your data and sells them to KGB. So, databa= se=20 encryption (and not disk encryption) is the _only_ answer. > - I expect that most of the situations we attempt to prevent are > unlikely in the extreme, but we have various contractual and legal > obligations which mean we have to defend against them anyway. This is the point. > Of course, this loopback encryption with a boot-time passphrase may fail > if they take the rackmount UPS as *well*, and keep the machine powered > at all times ;) The server should listen to the (encrypted/digitally signed) "Heartbeat" of= a=20 password server through the net to prevent this kind of attack. See you ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it