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
>
>