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 020B4D1D301 for ; Fri, 5 Mar 2004 16:33:47 +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 85563-07 for ; Fri, 5 Mar 2004 12:33:42 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 1A494D1CAD1 for ; Fri, 5 Mar 2004 12:33:34 -0400 (AST) Received: (qmail 5139 invoked by uid 500); 5 Mar 2004 16:36:11 -0000 Date: Fri, 5 Mar 2004 10:36:11 -0600 From: Bruno Wolff III To: Matt Davies Cc: Mitch Pirtle , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Message-ID: <20040305163611.GA28533@wolff.to> Mail-Followup-To: Matt Davies , Mitch Pirtle , pgsql-admin@postgresql.org References: <200403050951.33230.silvanadimartino@tin.it> <40484403.70001@aldratech.com> <200403051245.10681.silvanadimartino@tin.it> <20040305121254.GK13042@nemesis.ox.icnet.uk> <40488640.1040409@spacemonkeylabs.com> <1078497790.404891feec25d@www.mattdavies.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1078497790.404891feec25d@www.mattdavies.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/51 X-Sequence-Number: 12621 On Fri, Mar 05, 2004 at 07:43:10 -0700, Matt Davies wrote: > And how does one account for key information? If one encrypts any information > deemed worthy to be a key then you have to decrypt the entire database to find > particular information. It depends on what kinds of searches you do. If they are searches for equals, you can use one way hashes and still have efficient searches. "Transluscent Databases" has some other tricks in it along these lines.