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