Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZNgT-00032X-8C for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Mar 2023 03:08:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pZNgR-0003Xt-EG for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Mar 2023 03:08:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZNgR-0003Xj-4d for pgsql-hackers@lists.postgresql.org; Tue, 07 Mar 2023 03:08:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZNgK-0007iC-Ah for pgsql-hackers@lists.postgresql.org; Tue, 07 Mar 2023 03:08:10 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZNgJ-00008E-Ng for pgsql-hackers@lists.postgresql.org; Tue, 07 Mar 2023 03:08:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pZNgI-004uu8-40 for pgsql-hackers@lists.postgresql.org; Tue, 07 Mar 2023 03:08:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Moving forward with TDE To: pgsql-hackers@lists.postgresql.org From: Chris Travers Cc: Bruce Momjian , David Christensen Date: Tue, 07 Mar 2023 03:07:16 +0000 User-Agent: pgcommitfest X-cfsender: einhverfr In-Reply-To: References: Message-ID: <167815843656.628976.12976330942316643973.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIG5vdCB0ZXN0ZWQKU3BlYyBjb21wbGlhbnQ6ICAgICAgICAg ICBub3QgdGVzdGVkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgbm90IHRlc3RlZAoKSSBoYXZl IGRlY2lkZWQgdG8gd3JpdGUgYSByZXZpZXcgaGVyZSBpbiB0ZXJtcyBvZiB3aGV0aGVyIHdlIHdh bnQgdGhpcyBmZWF0dXJlLCBhbmQgcGVyaGFwcyB0aGUgd2F5IHdlIHNob3VsZCBsb29rIGF0IGVu Y3J5cHRpb24gYXMgYSBwcm9qZWN0IGRvd24gdGhlIHJvYWQsIHNpbmNlIEkgdGhpbmsgdGhpcyBp cyBvbmx5IHRoZSBiZWdpbm5pbmcuICBJIGFtIGhvcGluZyB0byBydW4gc29tZSBmdWxsIHRlc3Rz IG9mIHRoZSBmZWF0dXJlIHNvbWV0aW1lIGluIGNvbWluZyB3ZWVrcy4gIFJpZ2h0IG5vdyB0aGlz IHJldmlldyBpcyBsaW1pdGVkIHRvIHRoZSBkb2N1bWVudGF0aW9uIGFuZCBkb2N1bWVudGVkIGZl YXR1cmUuDQoNCkZyb20gdGhlIGRvY3VtZW50YXRpb24sIHRoZSBwcmltYXJ5IHRocmVhdCBtb2Rl bCBvZiBUREUgaXMgdG8gcHJldmVudCBkZWNyeXB0aW9uIG9mIGRhdGEgZnJvbSBhcmNoaXZlZCB3 YWwgc2VnbWVudHMgKGFuZCBkYXRhIGZpbGVzKSwgZm9yIGV4YW1wbGUgb24gYSBiYWNrdXAgc3lz dGVtLiAgV2hpbGUgdGhlcmUgYXJlIG90aGVyIG1ldGhvZHMgYXJvdW5kIHRoaXMgcHJvYmxlbSB0 byBkYXRlLCBJIHRoaW5rIHRoYXQgdGhpcyBmZWF0dXJlIGlzIHdvcnRoIHB1cnN1aW5nIGZvciB0 aGF0IHJlYXNvbi4gIEkgd2FudCB0byBhZGRyZXNzIGEgY291cGxlIG9mIHJlYXNvbnMgZm9yIHRo aXMgYW5kIHRoZW4gZ28gaW50byBzb21lIHJlc2VydmF0aW9ucyBJIGhhdmUgYWJvdXQgaG93IHNv bWUgb2YgdGhpcyBpcyBkb2N1bWVudGVkLg0KDQpUaGVyZSBhcmUgY3VycmVudCB3b3JrYXJvdW5k cyB0byBlbnN1cmluZyBlbmNyeXB0aW9uIGF0IHJlc3QsIGJ1dCB0aGVzZSBoYXZlIGEgbnVtYmVy IG9mIHByb2JsZW1zLiAgRW5jcnlwdGlvbiBwYXNzcGhyYXNlcyBlbmQgdXAgbHlpbmcgYXJvdW5k IHRoZSBzeXN0ZW0gaW4gdmFyaW91cyBwbGFjZXMuICBLZXkgcm90YXRpb24gaXMgb2Z0ZW4gZGlm ZmljdWx0LiAgQW5kIG9uZSBtaXN0YWtlIGNhbiBlYXNpbHkgcmVuZGVyIGFsbCBlZmZvcnRzIGlu ZWZmZWN0aXZlLiAgVERFIHNvbHZlcyB0aGVzZSBwcm9ibGVtcy4gIFRoZSBvdmVyYWxsIGRlc2ln biBmcm9tIHRoZSBpbnRlcm5hbCBkb2NzIGxvb2tzIHNvbGlkLiAgVGhpcyBkZWZpbml0ZWx5IGlz IHNvbWV0aGluZyBJIHdvdWxkIHJlY29tbWVuZCBmb3IgbWFueSB1c2Vycy4NCg0KSSBoYXZlIGEg Y291cGxlIHNtYWxsIGNhdmVhdHMgdGhvdWdoLiAgRW5jcnlwdGlvbiBvZiBkYXRhIGlzIGEgbGFy Z2UgdG9waWMgYW5kIHRoZXJlIGlzbid0IGEgb25lLXNpemUtZml0cy1hbGwgc29sdXRpb24gdG8g aW5kdXN0cmlhbCBvciBzdGF0ZSByZXF1aXJlbWVudHMuICBIYXZpbmcgYWxsIHRoaXMga2V5IG1h bmFnZW1lbnQgYXZhaWxhYmxlIGluIFBvc3RncmVTUUwgaXMgYSB2ZXJ5IGdvb2QgdGhpbmcuICBM b25nIHJ1biBpdCBpcyBsaWtlbHkgdG8gZW5kIHVwIGJlaW5nIGV4dGVuc2libGUsIGFuZCB0aGVy ZWZvcmUgYm90aCBtb3JlIHBvd2VyZnVsIGFuZCBvZmZlcmluZyBhIHdpZGVyIHJhbmdlIG9mIGNo b2ljZXMgZm9yIHNvbHV0aW9uIGFyY2hpdGVjdHMuICBJbXBsZW1lbnRpbmcgZW5jcnlwdGlvbiBp cyBhbHNvIHNvbWV0aGluZyB0aGF0IGlzIGVhc3kgdG8gbWVzcyB1cC4gIEZvciB0aGlzIHJlYXNv biBJIHRoaW5rIGl0IHdvdWxkIGJlIGdyZWF0IGlmIHdlIGhhZCBhIHN0YW5kYXJkaXplZCBmb3Jt YXQgZm9yIGRpc2N1c3NpbmcgZW5jcnlwdGlvbiBvcHRpb25zIHRoYXQgd2UgY291bGQgdXNlIGdv aW5nIGZvcndhcmQuICBJIGRvbid0IHRoaW5rIHRoYXQgc2hvdWxkIGJlIGhlbGQgYWdhaW5zdCB0 aGlzIHBhdGNoIGJ1dCBJIHRoaW5rIHdlIG5lZWQgdG8gc3RhcnQgZGlzY3Vzc2luZyBpdCBub3cg YmVjYXVzZSBpdCB3aWxsIGJlIGEgYmlnZ2VyIHByb2JsZW0gbGF0ZXIuDQoNCkEgc2Vjb25kIGNh dmVhdCBJIGhhdmUgaXMgdGhhdCBrZXkgbWFuYWdlbWVudCBpcyBhIHRvcGljIHdoZXJlIHlvdSBy ZWFsbHkgbmVlZCBhIGdvb2Qgb3ZlcnZpZXcgb2YgaW50ZXJuYWxzIGluIG9yZGVyIHRvIGltcGxl bWVudCBlZmZlY3RpdmVseS4gIElmIHlvdSBkb24ndCBrbm93IGhvdyBhbiBTU0wgaGFuZHNoYWtl IHdvcmtzIG9yIHdoYXQgaXMgaW4gYSBjZXJ0aWZpY2F0ZSwgeW91IGNhbiBlYXNpbHkgbWFrZSBt aXN0YWtlcyBpbiBzZXR0aW5nIHVwIFNTTC4gIEkgY2FuIHNlZSB0aGUgc2FtZSB0aGluZyBoYXBw ZW5pbmcgaGVyZS4gIEZvciBleGFtcGxlLCBJIGRvbid0IHRoaW5rIGl0IHdvdWxkIGJlIHNhZmUg dG8gbGVhdmUgdGhlIEtFSyBvbiBhbiBlbmNyeXB0ZWQgZmlsZXN5c3RlbSB0aGF0IGlzIGRlY3J5 cHRlZCBhdCBydW50aW1lIChvciBhdCBsZWFzdCBJIHdvdWxkbid0IGNvbnNpZGVyIHRoYXQgc2Fm ZSAtLSB5b3VyIGFwcGV0aXRlIGZvciByaXNrIG1heSB2YXJ5KS4NCg0KTXkgcHJvcG9zYWwgd291 bGQgYmUgdG8gaGF2ZSBidWlsZCBhIHRlbXBsYXRlIGZvciBlbmNyeXB0aW9uIG9wdGlvbnMgaW4g dGhlIGRvY3VtZW50YXRpb24uICBUaGlzIGNvdWxkIGluY2x1ZGUgdG9waWNzIGxpa2UgU1NMIGFz IHdlbGwuICBJbiBzdWNoIGEgdGVtcGxhdGUgd2UnZCBoYXZlIHNlY3Rpb25zIGxpa2UgIlRocmVh dCBtb2RlbCwiICAiSG93IGl0IHdvcmtzLCIgIkltcGxlbWVudGF0aW9uIFJlcXVpcmVtZW50cyIg YW5kIHNvIGZvcnRoLiAgQWdhaW4gSSBkb24ndCB0aGluayB0aGlzIG5lZWRzIHRvIGJlIHBhcnQg b2YgdGhlIGN1cnJlbnQgcGF0Y2ggYnV0IEkgdGhpbmsgaXQgaXMgc29tZXRoaW5nIHdlIG5lZWQg dG8gc3RhcnQgdGhpbmtpbmcgYWJvdXQgbm93LiAgTWF5YmUgYWZ0ZXIgdGhpcyBnb2VzIGluLCBJ IGNhbiBwcmVzZW50IGEgcHJvcG9zZWQgZG9jdW1lbnRhdGlvbiBwYXRjaC4NCg0KSSB3aWxsIGFs c28gbm90ZSB0aGF0IEkgZG9uJ3QgY29uc2lkZXIgbXlzZWxmIHRvIGJlIHZlcnkgcXVhbGlmaWVk IG9uIHRvcGljcyBsaWtlIGVuY3J5cHRpb24uICBJIGNhbiByZWFzb24gYWJvdXQga2V5IG1hbmFn ZW1lbnQgdG8gc29tZSBleHRlbnQgYnV0IHNvbWUgaW1wbGVtZW50YXRpb24gZGV0YWlscyBtYXkg YmUgYmV5b25kIG1lLiAgSSB3b3VsZCBob3BlIHdlIGNvdWxkIGdldCBzb21lIGV4dHJhIHJldmll dyBvbiB0aGlzIHBhdGNoIHNldCBzb29uLg==