Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D588B9FA170 for ; Thu, 8 Feb 2007 04:13:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 60669-04 for ; Thu, 8 Feb 2007 04:13:35 -0400 (AST) X-Greylist: delayed 21:50:45.087723 by SQLgrey-1.7.4 Received: from mx.imatech.net (mx.imatech.net [81.255.215.253]) by postgresql.org (Postfix) with ESMTP id 21F569FB290 for ; Thu, 8 Feb 2007 04:13:36 -0400 (AST) X-AuthUser: olivier.boissard@cerene.fr Received: from [200.200.200.34] ([195.6.193.141]:56486) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Thu, 8 Feb 2007 09:13:36 +0100 Message-ID: <45CADBBC.1020108@cerene.fr> Date: Thu, 08 Feb 2007 09:13:48 +0100 From: Olivier Boissard Organization: cerene services User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Andrew Sullivan CC: pgsql-admin@postgresql.org Subject: Re: database encryption References: <45C9A887.9040202@cerene.fr> <20070207143548.GC30604@phlogiston.dyndns.org> In-Reply-To: <20070207143548.GC30604@phlogiston.dyndns.org> Content-Type: multipart/mixed; boundary="------------020501010604000709080505" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/123 X-Sequence-Number: 24588 This is a multi-part message in MIME format. --------------020501010604000709080505 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Andrew Sullivan a écrit : > On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote: > >> I saw on the web that there is a contrib (pgcypto) but I can't estimate >> its efficiency >> > > Well, it works for some people. What are you trying to accomplish > with "database encryption"? > > A > > I would like to insert sensitive data into postgresql tables. These informations must be well-protected as they are confidential but they must be "decrypted" by php programs too. (These PHP programs will be encrypted by php encryptions program.) I was thinking about a system in which only the php programs will be able to manage stored informations. In case of theft or unexpected access to servers nobody could be able to retrieve the stored data without the authorized key. Olivier --------------020501010604000709080505 Content-Type: text/x-vcard; charset=utf-8; name="olivier.boissard.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="olivier.boissard.vcf" begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France email;internet:olivier.boissard@cerene.fr tel;work:03.25.74.11.78 tel;fax:03.25.78.39.67 version:2.1 end:vcard --------------020501010604000709080505--