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 3EC735334F for ; Fri, 1 Apr 2005 22:43:11 +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 70285-01 for ; Fri, 1 Apr 2005 21:43:01 +0000 (GMT) Received: from mail0.rawbw.com (mail0.rawbw.com [198.144.192.41]) by svr1.postgresql.org (Postfix) with ESMTP id 71D1D53250 for ; Fri, 1 Apr 2005 22:43:00 +0100 (BST) Received: from kzsu.stanford.edu (m208-84.dsl.rawbw.com [198.144.208.84]) by mail0.rawbw.com (8.11.6p2/8.11.6) with ESMTP id j31Lh2b17595 for ; Fri, 1 Apr 2005 13:43:02 -0800 (PST) Message-Id: <200504012143.j31Lh2b17595@mail0.rawbw.com> To: pgsql-admin@postgresql.org Subject: Disk Encryption - Postgresql vs. Oracle In-reply-to: <424C9067.2030405@doitonce.net.au> X-Mailer: MH-E 7.82; nmh 1.0.4; GNU Emacs 21.1.1 Date: Fri, 01 Apr 2005 13:43:01 -0800 From: Joseph Brenner X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/24 X-Sequence-Number: 17037 I was talking to someone just recently who was saying that they were thinking about going with Oracle rather than Postgresql because Oracle has a their story in place about how to do disk encryption. So I am of course, looking into how to do it with Postgresql... (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.) contrib/pgcrypto looks pretty interesting, but I gather it's intended to let you encrypt particular fields inside a database, rather than the whole ball of wax. 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? I see there's a general Linux disk encryption FAQ out there: http://www.telenovela-world.com/~spade/linux/howto/Disk-Encryption-HOWTO/index.html Doing some searches of the archives, I haven't turned up much discussion more recent than about a year ago, e.g. http://archives.postgresql.org/pgsql-admin/2004-03/msg00049.php Is there anything new on this front?