From: Michael Fuhr <mike@fuhr.org>
To: Olivier Boissard <olivier.boissard@cerene.fr>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: database encryption
Date: Thu, 8 Feb 2007 04:52:21 -0700
Message-ID: <20070208115221.GA76441@winnie.fuhr.org> (raw)
In-Reply-To: <45CADBBC.1020108@cerene.fr>
References: <45C9A887.9040202@cerene.fr>
<20070207143548.GC30604@phlogiston.dyndns.org>
<45CADBBC.1020108@cerene.fr>
On Thu, Feb 08, 2007 at 09:13:48AM +0100, Olivier Boissard wrote:
> 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.
What about theft or compromise of the server running the PHP code?
In general it's a good idea to encrypt and decrypt as close to where
the cleartext is needed to limit exposure, but you should also
consider the vulnerability of the system that holds the key. For
some applications it might make sense to use public-key encryption
with the exposed (e.g., Internet-facing) server having only the
public (encryption) key and a more protected backend server having
the corresponding private (decryption) key.
Without knowing the requirements and the threat model it's impossible
to suggest a suitable solution. Can you be more specific about what
you're trying to do?
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, olivier.boissard@cerene.fr, ajs@crankycanuck.ca
Subject: Re: database encryption
In-Reply-To: <20070208115221.GA76441@winnie.fuhr.org>
References: <45C9A887.9040202@cerene.fr> <20070207143548.GC30604@phlogiston.dyndns.org> <45CADBBC.1020108@cerene.fr> <20070208115221.GA76441@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox