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 CC3F7D1DB9F for ; Mon, 8 Mar 2004 17:31:39 +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 59297-09 for ; Mon, 8 Mar 2004 13:31:36 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 4C54FD1DB51 for ; Mon, 8 Mar 2004 13:31:34 -0400 (AST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 1054198; Mon, 08 Mar 2004 09:27:13 -0800 Message-ID: <404CAD5D.6010503@joeconway.com> Date: Mon, 08 Mar 2004 09:29:01 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Silvana Di Martino Cc: Peter Galbavy , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403051251.54463.silvanadimartino@tin.it> <00b701c404f0$562f2950$152ca8c0@petersdesktopho> <200403081226.10550.silvanadimartino@tin.it> In-Reply-To: <200403081226.10550.silvanadimartino@tin.it> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/128 X-Sequence-Number: 12697 Silvana Di Martino wrote: > Oracle has a built-in feature for encrypting/decrypting this password's > password. Right, and this master password is only protected because Oracle is closed source. It is not possible to do the same thing with Postgres because you could find the master key (or the algorithm to produce it) in the source code. However this amounts to "security by obscurity", and anyone serious about encryption will tell you it is insufficient. There is no way to have cryptographically sound protection of your data using a key embedded in the software like that. Joe