Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4E7106331D2 for ; Wed, 7 Apr 2010 07:24:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18931-03 for ; Wed, 7 Apr 2010 10:24:22 +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 AB912634A2F for ; Wed, 7 Apr 2010 07:24:22 -0300 (ADT) Received: by bwz8 with SMTP id 8so713678bwz.3 for ; Wed, 07 Apr 2010 03:24:20 -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; bh=exuuyH7BVRuDsvwR/gXsc4aHqfWalvF6ilwROTsZRjk=; b=jGwNFTBW2mfnoMCP2N9tH29VKtpMpF+gmlBlQClQg6sX4FCf3epu7lo1/wsLBvq39p voZyZoyJhQt8i60SL5fEH07O5xFrHWReSfZCwMh84lUaAm6bZo5+/LdYBeOMUSPbtjhD LuRIf6j9yff0r7h68uKgFGhUjR0TfrtPvpqEE= 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; b=CLqXoZ5jHrKxYzqiEoLLJpn768bz6a7KOSe3Eb/yWYeRO2qf+vZpMLaKpfOTSR4/Gf XR2d0ZSUzEYO3vZEqPsd5vDPMVSPcerx47/6Cy6XFNUI2qZrOpoVFaMLQszDYK4Qw9SY OG8KfH4o/X6xCrQngS0j9UbStXGU4wSXKmvRU= MIME-Version: 1.0 Received: by 10.204.101.6 with HTTP; Wed, 7 Apr 2010 03:24:19 -0700 (PDT) In-Reply-To: <4BBA6924.5050305@joeconway.com> References: <4BB774D4.3070306@joeconway.com> <4BBA05E80200002500030493@gw.wicourts.gov> <4BBA6924.5050305@joeconway.com> Date: Wed, 7 Apr 2010 13:24:19 +0300 Received: by 10.204.161.197 with SMTP id s5mr9139509bkx.90.1270635859934; Wed, 07 Apr 2010 03:24:19 -0700 (PDT) Message-ID: Subject: Re: Database level encryption From: Timothy Madden To: "Andreas 'ads' Scherbaum" Cc: Kevin Grittner , Scott Marlowe , pgsql-admin@postgresql.org, Joe Conway Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/61 X-Sequence-Number: 34155 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