Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dKrir-0003qx-4Y for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2017 19:43:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dKriq-00050q-3q for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2017 19:43:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dKrip-00050h-Jj for pgsql-hackers@postgresql.org; Tue, 13 Jun 2017 19:43:27 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dKrih-0002RH-LK for pgsql-hackers@postgresql.org; Tue, 13 Jun 2017 19:43:26 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id E910A20B76; Tue, 13 Jun 2017 15:43:17 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute7.internal (MEProxy); Tue, 13 Jun 2017 15:43:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= fm1; bh=PxJWgXvscImNIcWe+86Sn4JMU2yYkPk+FeqW0HlpLBw=; b=ZLd7K0j/ fHo7oSAxtUgrbH1hqxX72kXmoNjzSnnQRrc0lvzkVdOOEMyaln0AzirDpFKeOMEA yZ5ZUd9doS4lJQO6yaP89QSC2tQ3rxrXWCaawwc1DK8xWu9m7bzhjqLYZtPnO2fH zCNLavo9KbNAdC7e/1X8N22KnD58WpRhqjwN+EllFp306SfoOQzqlnQ6/Lrn/Ik3 Ky9GNTxNsVOZDaweu0DRfpF9+k+PNkwpZ0pzE8nCRBwkfDi5WuzdD+ZQBL8ADJ+U d9GCepgitwG4iX89/tTzTzVbMaL1C4FhiJiTHbokokMuIMrLNu2UEYrCFYBmEodn v/HU3OL3UXAUDQ== X-ME-Sender: X-Sasl-enc: dwp9c27fKNe2Go35cwhipF3Z3FeFMwnHlLxPVF7myq4d 1497382997 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id DE29924953; Tue, 13 Jun 2017 15:43:16 -0400 (EDT) Subject: Re: WIP: Data at rest encryption To: Stephen Frost , Bruce Momjian References: <20170613162301.GF3151@tamriel.snowman.net> <20170613164442.GD13873@momjian.us> <20170613170132.GH3151@tamriel.snowman.net> <20170613171356.GG13873@momjian.us> <20170613172459.GL3151@tamriel.snowman.net> <20170613174329.GK13873@momjian.us> <20170613182339.GP3151@tamriel.snowman.net> <20170613182910.GN13873@momjian.us> <20170613183858.GR3151@tamriel.snowman.net> <20170613185622.GO13873@momjian.us> <20170613192011.GS3151@tamriel.snowman.net> Cc: Ants Aasma , Robert Haas , PostgreSQL-development From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Tue, 13 Jun 2017 15:43:14 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: <20170613192011.GS3151@tamriel.snowman.net> Content-Type: text/plain; charset=windows-1252 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 6/13/17 15:20, Stephen Frost wrote: > No, the benefit is that the database administrator can configure it and > set it up and not have to get an OS-level administrator involved. There > may also be other reasons why filesystem-level encryption is difficult > to set up or use in a certain environment, but this wouldn't depend on > anything OS-related and therefore could be done. Let's see a proposal in those terms then. How easy can you make it, compared to existing OS-level solutions, and will that justify the maintenance overhead? Considering how ubiquitous file-system encryption is, I have my doubts that the trade-offs will come out right, but let's see. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers