From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Peter Darley <pdarley@kinesis-cem.com>
Cc: Pgsql-Admin <pgsql-admin@postgresql.org>
Subject: Re: Encrypted Disks
Date: Fri, 23 Sep 2005 10:23:44 -0500
Message-ID: <1127489023.30825.82.camel@state.g2switchworks.com> (raw)
In-Reply-To: <PDEOIIFFBIAABMGNJAGPCEMLDOAA.pdarley@kinesis-cem.com>
References: <PDEOIIFFBIAABMGNJAGPCEMLDOAA.pdarley@kinesis-cem.com>
On Thu, 2005-09-22 at 17:18, Peter Darley wrote:
> Folks,
>
> A client is asking us about data security, and keeping data encrypted on
> disk. I recall there was some discussion about this before, including
> things like for it to be secure an operator would need to put in a key when
> the disk is mounted, that once it is mounted anyone with permissions to the
> disk can read it, etc.
>
> Given these drawbacks, I'm wondering if anyone has used an encrypted fs for
> PostgreSQL and if so, what they found in terms of speed. Would this be a
> big hit, or would it be pretty low impact? Also, does it cause any
> potential problems with recovery from a crash, etc?
You and your client need to back up and figure out which scenario you're
trying to protect against.
Encrypting the drive (with an external key) ensures that if someone
steals the disks, or gets hold of the raw db files that they can't get
the data out.
However, if they hack into the machine that is accessing the database,
encrypting the drives doesn't nothing for you.
So, which scenario are they trying to protect against? Once you know
the answer to that question, then you can look at different ways of
encrypting the data you are storing.
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: smarlowe@g2switchworks.com, pdarley@kinesis-cem.com
Subject: Re: Encrypted Disks
In-Reply-To: <1127489023.30825.82.camel@state.g2switchworks.com>
References: <PDEOIIFFBIAABMGNJAGPCEMLDOAA.pdarley@kinesis-cem.com> <1127489023.30825.82.camel@state.g2switchworks.com>
* 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