On Mon, Aug 22, 2011 at 3:40 AM, Condor <con...@stz-bg.com> wrote: > Hello ppl, > any one can tell me how I can secure linux server with database postgres > for example ? > Im thinking to make a cryptfs file system and to deploy database over the > cryptfs. The problem > here may will be when front end need any data for in/out cpus of the server > will aways > decrypt/encrypt data and performance will be very low. > > I remember a few months ago some one ask similar question about how he can > crypt data that is > stored on database and problem was the key. Key is stored on the same > server if some one > get access can decrypt data. > > Any one have some ideas how to make something like crypt bubble and to > store database there ? > Or something else ? > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
Recently, as a test I created a database using encfs and ran some tests against the same database but unencrypted. In both cases the data was being stored on a 500 GB external hard drive connected via USB2 to an HP laptop running Linux Fedora 15. I found that the encrypted database ran 15-20% slower on PostgreSQL 9.0.4 on most queries. -- Mike Nolan
