Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dL4Jf-0003wA-WF for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Jun 2017 09:10:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dL4Jf-0003lg-Iv for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Jun 2017 09:10:19 +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 1dL4I9-00012h-HR for pgsql-hackers@postgresql.org; Wed, 14 Jun 2017 09:08:45 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dL4I6-0001Rz-1Z for pgsql-hackers@postgresql.org; Wed, 14 Jun 2017 09:08:44 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id D892E21C1FCA; Wed, 14 Jun 2017 12:08:40 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Date: Wed, 14 Jun 2017 12:04:26 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1497431320; bh=RblHEZjMTktgKoGgZaIgmpK/5gKsBdkKQccX7GT7H/A=; h=From:To:Cc:Subject:References:In-Reply-To; b=Wdpa+NP8GALAXZ1yZlQxk3+smSficxla5fBXOH+zc2b2ewu+tChEXX9V3flXk/7Jd f5ezjeG+T7aFqtNYsk621Wv/Q1ITj7edNWui5HHd4lP0pSO58YhHFrPPlGiYbtCYfp KdlkW/OM/kxoMDjijD5P4+OudbqQqNQB27oJl9bE= From: Aleksander Alekseev To: Peter Eisentraut Cc: Ants Aasma , Robert Haas , PostgreSQL-development Subject: Re: WIP: Data at rest encryption Message-ID: <20170614090426.GA7249@e733.localdomain> References: <06b6db11-3a3f-4d24-6f57-450f96ecda84@2ndquadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="YZ5djTAD1cGYuMQK" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.8.3 (2017-05-23) 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 --YZ5djTAD1cGYuMQK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Ants, On Tue, Jun 13, 2017 at 09:07:49AM -0400, Peter Eisentraut wrote: > On 6/12/17 17:11, Ants Aasma wrote: > > I'm curious if the community thinks this is a feature worth having? > > Even considering that security experts would classify this kind of > > encryption as a checkbox feature. >=20 > File system encryption already exists and is well-tested. I don't see > any big advantages in re-implementing all of this one level up. You > would have to touch every single place in PostgreSQL backend and tool > code where a file is being read or written. Yikes. I appreciate your work, but unfortunately I must agree with Peter. On Linux you can configure the full disc encryption using LUKS / dm-crypt in like 5 minutes [1]. On FreeBSD you can do the same using geli [2]. In my personal opinion PostgreSQL is already complicated enough. A few companies that hired system administrators that are too lazy to read two or three man pages is not a reason to re-implement file system encryption (or compression, or mirroring if that matters) in any open source RDBMS. [1] http://eax.me/dm-crypt/ [2] http://eax.me/freebsd-geli/ --=20 Best regards, Aleksander Alekseev --YZ5djTAD1cGYuMQK Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEECAokn0QZCoIHW4GpEEnCBLXCDtYFAllA/BgACgkQEEnCBLXC DtZKkRAAiFijk8qk96FT41nErfRDhuhovm+rXDDosOy36eW/x6hAVNXgEZrmvaUx K5fH4mq1KT2/WX7L1UrnsjIZcFLVhDPsciZUCq4H6j9CR/6QCxN4BVHKors1oiH1 Y/frisxOW4iPNaqy+OuUwNd94KWjfYV7KpxuDtpOH0h/ZJ74pHRBffVrzHL27PrH PQIuzqSyG9frZlvFLK3jpmOJIjhk31qHlX2sF01mibSUyOlEv1Rv5ojnN16GOqT9 DDXxurrB15kJKuC1wfnBmfueIOE0SMmwgExuZJHh5/QjmuStjnZuv11s3uPwRNzQ vxvDdm2OrGUH9SbHuLjBpmRm82ICsGxG23x20tbeF/Pf8Tv5VKdpoiB5GZuHiaYi pdqHW35jYV23zZO/IpRf+hSxqwDo7KPfeff9S1kKwbmFO0M5z64ziNTMX6sQcVQ4 vURdraWj84Pd4erJMrZjwqdHRQ8mb3XOmqGx6v1AV68jLFu6rriDDvejCd/JvA6g Qn8vp5nTK2ZMsOHajQdgRkU4eyOCHoO75829XZpAkwVtzzGySVRuKHtYLfMkAR+I jfI2/qoocZzAlMqnZEWHa7P90Bn4OFv+4/YVqb5rpAqYitk2sc6D3r8sMzh0p3Gc j5RlEEbyc3xhPjR5mn8WZz2bXU+rCIobftjHAVKAOGpU0YS3dtk= =ygF1 -----END PGP SIGNATURE----- --YZ5djTAD1cGYuMQK--