Search Postgresql Archives

Re: securing the sql server ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mon, Aug 22, 2011 at 3:40 AM, Condor <condor@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux