Re: scrambled data / security - Mailing list pgsql-general

From Justin Clift
Subject Re: scrambled data / security
Date
Msg-id 3CC718B7.5FB1C0F4@postgresql.org
Whole thread Raw
In response to scrambled data / security  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List 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

pgsql-general by date:

Previous
From: Jeffrey Baker
Date:
Subject: No long-lived transaction, still can't delete tuples
Next
From: Uros Gruber
Date:
Subject: Speeding query