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 46F4AD1D27F for ; Fri, 5 Mar 2004 12:08:04 +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 91549-03 for ; Fri, 5 Mar 2004 08:08:05 -0400 (AST) Received: from magic.lif.icnet.uk (magic.lif.icnet.uk [143.65.100.6]) by svr1.postgresql.org (Postfix) with ESMTP id E3DB1D1D17E for ; Fri, 5 Mar 2004 08:08:01 -0400 (AST) Received: from atlantis.ox.icnet.uk (atlantis.ox.icnet.uk [143.65.27.60]) by magic.lif.icnet.uk (8.9.3p2/8.9.3) with ESMTP id MAA00271 for ; Fri, 5 Mar 2004 12:08:03 GMT Received: from nemesis.ox.icnet.uk (mail@nemesis.ox.icnet.uk [143.65.27.59]) by atlantis.ox.icnet.uk (8.12.6/8.12.6) with ESMTP id i25C83PS012375 for ; Fri, 5 Mar 2004 12:08:03 GMT Received: from davee by nemesis.ox.icnet.uk with local (Exim 3.36 #1 (Debian)) id 1AzE7X-0004x5-00 for ; Fri, 05 Mar 2004 12:08:03 +0000 Date: Fri, 5 Mar 2004 12:08:02 +0000 From: Dave Ewart To: pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Message-ID: <20040305120802.GJ13042@nemesis.ox.icnet.uk> Mail-Followup-To: pgsql-admin@postgresql.org References: <20040305092041.GB13042@nemesis.ox.icnet.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.5.1+davee+cvs20040105i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/38 X-Sequence-Number: 12608 On Friday, 05.03.2004 at 11:17 +0000, Matt Clark wrote: > > What's wrong with using a LoopAES filesystem? It protects against > > someone walking off with the server, or at least the hard disk, and > > being able to see the data. > > Yes, but only if the password has to entered manually [1] at boot > time. And it gives zero protection against someone who gains root > access to the server. > > [...] > > [1] There are ways of avoiding having to enter the info manually, but > they're very tricky to implement securely. Not sure I follow this - there's no point AT ALL in using LoopAES if you can mount the encrypted partitions without needing manual intervention at boot time. Dave. -- Dave Ewart Dave.Ewart@cancer.org.uk Computing Manager, Epidemiology Unit, Oxford Cancer Research UK PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370