Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 09703634D61 for ; Wed, 7 Apr 2010 13:53:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 85338-02-7 for ; Wed, 7 Apr 2010 16:52:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id 090CE63482D for ; Wed, 7 Apr 2010 13:52:18 -0300 (ADT) Received: by bwz8 with SMTP id 8so1080479bwz.3 for ; Wed, 07 Apr 2010 09:52:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=5/1fOS8Qhmy+4zQ8mo18dTJWAWgQK+zIQECQBZGiWzo=; b=b8PKQlTNix2tHAoQTSCvi4tbgw9zim53pHKhRVinzliWD5sBRnIGYDaXzifaIGgwLh mSwP9ss9Er776NW0KT1nb5LTjQMNSwOEEy6HHaLLE6Hs6ET6KqV/M/OdkDpumJicDo4F oQ/gRrmvdzOoiJiPx30UCcSdrIGaTx06n0c3E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=S5cLaMp+kDATxkZVWt6CmwweAxdtOMe39/XlzEl1OX1+d3/B92WUtfCU4kt4v5RTC+ 0GeqpNQHqwefhq7VZbuxzFY+4r8GfF0N9LUw/DXqZMXjK6/6cnXjEaLj74I7OP0J+7/m uWJWLTjubI4YfZh9nnlJU90yt6cQC7DwNpZvA= MIME-Version: 1.0 Received: by 10.204.101.6 with HTTP; Wed, 7 Apr 2010 09:52:14 -0700 (PDT) In-Reply-To: <4fafa57d090e57bb44ec5a177ecf292e@intermodalsoftwaresolutions.net> References: <4fafa57d090e57bb44ec5a177ecf292e@intermodalsoftwaresolutions.net> Date: Wed, 7 Apr 2010 19:52:14 +0300 Received: by 10.204.23.193 with SMTP id s1mr2451476bkb.151.1270659134315; Wed, 07 Apr 2010 09:52:14 -0700 (PDT) Message-ID: Subject: Re: Database level encryption From: Timothy Madden To: Michael Gould Cc: "Andreas 'ads' Scherbaum" , Kevin Grittner , Scott Marlowe , pgsql-admin@postgresql.org, Joe Conway Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.951 tagged_above=-10 required=5 tests=AWL=0.648, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201004/69 X-Sequence-Number: 34163 Ok people thank you for your answers. Timothy Madden On Wed, Apr 7, 2010 at 3:25 PM, Michael Gould wrote: > Timothy, > > I've worked with SQL Anywhere which does have database encryption. =A0The= re > are pluses to having a encrypted db, but it did slow down the processing. > They also had the ability to encrypt stored procedures and triggers. =A0T= hat > didn't' seem to really slow down the system. > > That being said, the encryption will keep the normal user out of the syst= em, > but those aren't the people you need to worry about. The people you need = to > worry about are the real hackers and they will be able to get around this > type of encryption. =A0I'd like to see something to protect stored proced= ures > and triggers but overall I agree that a encrypted drive is probably the b= est > thing and require ssl connections. > > Best Regards > > Michael Gould > > > > "Timothy Madden" wrote: >> Andreas 'ads' Scherbaum wrote: >> >>> If someone captures the machine the bad guy can install a network >>> sniffer and steal the database passwords upon connect. >> >> I think protecting against a keylogger is a different issue than >> database encryption. Is this why database encryption is "not needed" >> for PostgreSQL, as people here say ? >> >> >>>> With an encrypted database, you need the password anytime you connect, >>>> even if another application already has an open connection. >>> >>> See above, this doesn't help. >>> >>> If someone get's root access to your machine, nothing (no filesystem >>> and no database encryption) is goint to help you here. >> >> >> I would have to disagree with you here. The whole point of encryption >> is that you need the key in order to get your data back. >> >> >> Timothy Madden >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> > > >