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 1me4Yo-00087H-2y for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Oct 2021 00:06:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1me4Yn-0002wF-1N for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Oct 2021 00:06:53 +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 1me4Ym-0002w5-PF for pgsql-hackers@lists.postgresql.org; Sat, 23 Oct 2021 00:06:52 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1me4Yk-00061p-FA for pgsql-hackers@postgresql.org; Sat, 23 Oct 2021 00:06:51 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1me4Yg-0003m7-4j; Fri, 22 Oct 2021 20:06:46 -0400 Date: Fri, 22 Oct 2021 20:06:46 -0400 From: Bruce Momjian To: Stephen Frost Cc: Sasasu , Robert Haas , Andres Freund , PostgreSQL-development Subject: Re: XTS cipher mode for cluster file encryption Message-ID: <20211023000646.GD26156@momjian.us> References: <20211015212109.ugwjuhe4lzymnorg@alap3.anarazel.de> <4b73c57e-0941-9e66-ea7e-087793c4c927@sasa.su> <20211019185456.GV20998@tamriel.snowman.net> <46bc5203-0a3c-0426-e69f-5f2997648b35@sasa.su> <20211020122407.GW20998@tamriel.snowman.net> <20211021172812.GZ20998@tamriel.snowman.net> <6f4074f6-c1bc-49e8-b6a8-ece52b52b799@sasa.su> <20211022153637.GC20998@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20211022153637.GC20998@tamriel.snowman.net> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Oct 22, 2021 at 11:36:37AM -0400, Stephen Frost wrote: > > I am not re-discuss using CTR for heap table. I mean use some CTR-like > > algorithm *only* for WAL encryption. My idea is exactly the same when you > > are typing "we hopefully aren't going to write different WAL records at the > > same LSN and so using the LSN there should be alright." > > I don't like the idea of "CTR-like". What's wrong with using CTR for > WAL encryption? Based on the available information, that seems like the > exact use-case for CTR. Agreed. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.