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 962F1D1D105 for ; Fri, 5 Mar 2004 14:43:29 +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 30473-09 for ; Fri, 5 Mar 2004 10:43:24 -0400 (AST) Received: from mail.mattdavies.net (mail.mattdavies.net [64.122.21.130]) by svr1.postgresql.org (Postfix) with ESMTP id DA127D1D72D for ; Fri, 5 Mar 2004 10:43:13 -0400 (AST) Received: (qmail 43546 invoked by uid 89); 5 Mar 2004 14:43:11 -0000 Received: from unknown (HELO matt.mattdavies.net) (127.0.0.1) by localhost with SMTP; 5 Mar 2004 14:43:11 -0000 Received: (from nobody@localhost) by matt.mattdavies.net (8.12.8p1/8.12.8/Submit) id i25EhBhl043543; Fri, 5 Mar 2004 07:43:11 -0700 (MST) X-Authentication-Warning: matt.mattdavies.net: nobody set sender to matt@mattdavies.net using -f Received: from hif-koby7.hill.af.mil (hif-koby7.hill.af.mil [137.241.250.102]) by www.mattdavies.net (IMP) with HTTP for ; Fri, 5 Mar 2004 07:43:10 -0700 Message-ID: <1078497790.404891feec25d@www.mattdavies.net> Date: Fri, 5 Mar 2004 07:43:10 -0700 From: Matt Davies To: Mitch Pirtle Cc: pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) 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> In-Reply-To: <40488640.1040409@spacemonkeylabs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.2 X-Originating-IP: 137.241.250.102 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/44 X-Sequence-Number: 12614 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. Of course, you could keep keys unencrypted for use, but then again, why encrypt it at all? Quoting Mitch Pirtle : > Dave Ewart wrote: > > > If you find any 'automated' front-end to do this at the database-level, > > rather than something like loopback at the filesystem level or at the > > field level for specific fields, I think there would be a lot of > > interest. > > But that is the problem, isn't it? Any 'automated' > encryption/decryption will be just as useful to the would-be perpetrator > of data theft. This is like having an automatic alarm system on your > car that works for anyone that walks up to it. > > The same logic applies to encrypting the data in the database - > somewhere on your server the application has to know how to decrypt it, > and that means anyone that gains access to your server will have that > ability also... > > I understand (and demand) requiring SSL connections for database > clients, and MD5 hashing of passwords before storing in the database, > but implementing two-way encryption of database data just doesn't make > sense to me. > > -- Mitch > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >