Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dKu3J-0002Pz-9K for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2017 22:12:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dKu3H-0003Uw-FN for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jun 2017 22:12:43 +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 1dKu1k-0000nT-WE for pgsql-hackers@postgresql.org; Tue, 13 Jun 2017 22:11:09 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dKu1h-0005JR-Kd for pgsql-hackers@postgresql.org; Tue, 13 Jun 2017 22:11:08 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 5EBFC5F795; Tue, 13 Jun 2017 18:11:04 -0400 (EDT) Date: Tue, 13 Jun 2017 18:11:04 -0400 From: Stephen Frost To: Peter Eisentraut Cc: Bruce Momjian , Ants Aasma , Robert Haas , PostgreSQL-development Subject: Re: WIP: Data at rest encryption Message-ID: <20170613221104.GT3151@tamriel.snowman.net> References: <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> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="G/iWsUb1WhJWdEUz" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-117-generic (x86_64) X-Uptime: 18:05:56 up 35 days, 22:38, 15 users, load average: 0.12, 0.11, 0.13 User-Agent: Mutt/1.5.21 (2010-09-15) 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 --G/iWsUb1WhJWdEUz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Peter, * Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote: > 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. >=20 > 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? =46rom the original post on this thread, which included a WIP patch: ---------------------------------- Usage =3D=3D=3D=3D=3D Set up database like so: (read -sp "Postgres passphrase: " PGENCRYPTIONKEY; echo; export PGENCRYPTIONKEY initdb -k -K pgcrypto $PGDATA ) Start PostgreSQL: (read -sp "Postgres passphrase: " PGENCRYPTIONKEY; echo; export PGENCRYPTIONKEY postgres $PGDATA ) ---------------------------------- That certainly seems very straight-forward to me, though I expect that packagers would probably improve upon it further. > Considering how ubiquitous file-system encryption is, I have my doubts > that the trade-offs will come out right, but let's see. There's definitely environments out there where DBAs aren't able to have root privileges and that limits what they're able to do. I'm not really sure how to objectively weigh "you don't need to be root to encrypt the database" vs. maintenance overhead of this feature. Subjectively, for my 2c anyway, it seems well worth it, but that's naturally subjective. :) Thanks! Stephen --G/iWsUb1WhJWdEUz Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJZQGL3AAoJEO1sijiDR2RVY5MP/jYml4oq4mWvQxoxs8M8PGwv i7D2tKPme7JWeloDlmlpezREQWHQaVh7HX/EI6lft/ccvxxIVeq1hgtRbTz6W0oH 7jLEsqxGlMFxNARKJ7jp2zSjrp7O4oRY8knjTeEyEWDgaRrTn5AUKpzkVEP28oby /RuEaLkqNHrF1hEsuygLq8XKMvS7f69zTZcP7XfGBVW7oMGZFBTZYbaNJVyNbc0O djHfgHVQIpmta/SXTj4+zVhTSI2MK4EXXis841V2YVutSBmKseHRHxbRC8rpPrwP 8goE7vFXzFBkeLWLRW2mqkTNhhSKvpIYjU/B5ZlhznHWyIsdcKplcSJu2mMTBx/w rNyjTuyCZSA8Nu/3HI+yfBt0Js6iImQDRMCYv0lbRL0k3hQNgXnIztW99y3WYZle auZPc7+OzlVkqZ+FH7mSW7Vzhq8F4ZJY9/VDBmV+IcprufOSdtt4TQiPI2WQzmbV uSb2ou/mMlkDYvWWqpdwzIdGGMdp1wynWSCF217ZRMPqe06q4ZPL2fZ+ephlxDNe Jr6n2NgJeoVq8B3JR4Ui83KalkNHX22luuLS9MCtY3mKGPBvVQi3UQsOzqHv2ymm /UmSQPTUUkgIpejRaYpZum5E1sz0St7d5X0PfCHIs33gojhQOJb54y0zJgnRIa1B KH6IeMDgTFUjdUeVuuvI =qUfU -----END PGP SIGNATURE----- --G/iWsUb1WhJWdEUz--