X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA6E453A42 for ; Fri, 1 Apr 2005 22:54:54 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69716-08 for ; Fri, 1 Apr 2005 21:54:53 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 52F68539CA for ; Fri, 1 Apr 2005 22:54:52 +0100 (BST) Received: (qmail 11653 invoked by uid 500); 1 Apr 2005 22:11:39 -0000 Date: Fri, 1 Apr 2005 16:11:39 -0600 From: Bruno Wolff III To: Joseph Brenner Cc: pgsql-admin@postgresql.org Subject: Re: Disk Encryption - Postgresql vs. Oracle Message-ID: <20050401221139.GA11420@wolff.to> Mail-Followup-To: Bruno Wolff III , Joseph Brenner , pgsql-admin@postgresql.org References: <424C9067.2030405@doitonce.net.au> <200504012143.j31Lh2b17595@mail0.rawbw.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200504012143.j31Lh2b17595@mail0.rawbw.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/26 X-Sequence-Number: 17039 On Fri, Apr 01, 2005 at 13:43:01 -0800, Joseph Brenner wrote: > > (As to why you would *care* about disk encryption, I would guess > the scenario is you've got a bunch of guys in the back room > hot-swapping RAID drives, and you'd rather not post armed guards > there to watch what happens to the older units.) You really do need some sort of threat model (or government regulations that say what you need to do regardless) before you can make good decisions about security. > Maybe the right way to do it is to just get the OS to encrypt > everything, and not make postgresql jump through any extra hoops? Doing it in the OS is one possibility. That can work well against people stealing your hardware. It won't work so well in keeping sysadmins from snooping on your database.