Re: scrambled data / security

From: Justin Clift <justin(at)postgresql(dot)org>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: scrambled data / security
Date: 2002-04-24 20:42:31
Message-ID: 3CC718B7.5FB1C0F4@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Shaun,

Have you considered encrypting the partition which your PostgreSQL
database is on?

For example, Mandrake 8.2 has partition encryption with it, other
distributions may follow, etc.

The most widely used Linux partition encryption is the CryptoAPI
project:

http://cryptoapi.sf.net

I've had this in use in production systems for more than one year (on a
journalling filesystem) for some sensitive data, and its really stable.

:-)

PS - Can you please change your mail sending format to be normal plain
text? Some mail readers have a problem with multi-part email, etc (i.e
Netscape Communicator).

:-)

Regards and best wishes,

Justin Clift

"Johnson, Shaunn" wrote:
Howdy:

Running Postgres 7.1.3 on RedHat Linux 7.2.

Question about security. I have data that I want to
present, except that the information is really
sensitive.

I know there is a way to scramble the data so
that it appears garbled. How can I do that?
Where can I get find documents on that? (I'm
looking in the PostgreSQL book and might
be missing it).

Thanks!

-X

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Uros Gruber 2002-04-24 20:49:12 Help with performance
Previous Message Jeffrey Baker 2002-04-24 20:32:16 No long-lived transaction, still can't delete tuples