X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9E811D90C1 for ; Thu, 22 Sep 2005 19:15:17 -0300 (ADT) 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 32067-05 for ; Thu, 22 Sep 2005 22:15:12 +0000 (GMT) Received: from mail26.sea5.speakeasy.net (mail26.sea5.speakeasy.net [69.17.117.28]) by svr1.postgresql.org (Postfix) with ESMTP id 673CCD8AC3 for ; Thu, 22 Sep 2005 19:15:10 -0300 (ADT) Received: (qmail 30152 invoked from network); 22 Sep 2005 22:15:12 -0000 Received: from mail.kinesis-cem.com (HELO pdarley) (kinesis@[64.81.9.230]) (envelope-sender ) by mail26.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 22 Sep 2005 22:15:12 -0000 From: "Peter Darley" To: "Pgsql-Admin" Subject: Encrypted Disks Date: Thu, 22 Sep 2005 15:18:00 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/243 X-Sequence-Number: 18980 Folks, A client is asking us about data security, and keeping data encrypted on disk. I recall there was some discussion about this before, including things like for it to be secure an operator would need to put in a key when the disk is mounted, that once it is mounted anyone with permissions to the disk can read it, etc. Given these drawbacks, I'm wondering if anyone has used an encrypted fs for PostgreSQL and if so, what they found in terms of speed. Would this be a big hit, or would it be pretty low impact? Also, does it cause any potential problems with recovery from a crash, etc? Thanks, Peter Darley