Обсуждение: Encrypted database?

As part of an all-around security upgrade, I would like to secure the
data in my PostgreSQL db.  The threat I am concerned about is theft of
the server machine.  To protect the data in case the machine is
stolen, the best thing to do would be to keep the data encrypted on
the disk.

Is there a way to do this with PostgreSQL?  Or should I try to do the
encryption at the filesystem level?  The other alternative is to store
the PostgreSQL db files on a CFS system, but I'm worried that this
might have serious performance penalties.  Any other options I should
look into?

Thanks,

e

--
This message was my two cents worth.  Please deposit two cents into my
e-gold account by following this link:
http://rootworks.com/twocentsworth.cgi?102861
275A B627 1826 D627 ED35  B8DF 7DDE 4428 0F5C 4454

Your best bet is on transparent encrypted filesystems, like TCFS...
Since most of data will be in memory cache anyway, it won't be a real big
hit on cpu.

-alex

On Mon, 19 Jun 2000, Erich wrote:

>
> As part of an all-around security upgrade, I would like to secure the
> data in my PostgreSQL db.  The threat I am concerned about is theft of
> the server machine.  To protect the data in case the machine is
> stolen, the best thing to do would be to keep the data encrypted on
> the disk.
>
> Is there a way to do this with PostgreSQL?  Or should I try to do the
> encryption at the filesystem level?  The other alternative is to store
> the PostgreSQL db files on a CFS system, but I'm worried that this
> might have serious performance penalties.  Any other options I should
> look into?
>
> Thanks,
>
> e
>
>