Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5NQ2-0002Kv-OA for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Sep 2019 05:01:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i5NQ1-0007ve-3q for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Sep 2019 05:01:21 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5NQ0-0007n6-LH for pgsql-hackers@lists.postgresql.org; Wed, 04 Sep 2019 05:01:20 +0000 Received: from mail-wr1-x441.google.com ([2a00:1450:4864:20::441]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5NPy-0008TD-05 for pgsql-hackers@lists.postgresql.org; Wed, 04 Sep 2019 05:01:20 +0000 Received: by mail-wr1-x441.google.com with SMTP id g7so19719830wrx.2 for ; Tue, 03 Sep 2019 22:01:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=from:to:cc:subject:in-reply-to:references:comments:mime-version :content-id:content-transfer-encoding:date:message-id; bh=sG42hDNfb48CqwVntJcMfo+6b55nYPV47L8EMDkRlXk=; b=Z3Viaumo1E/gDNplNF2Rkr5KDxWnxnE5WkxKU+8xsGbYPvDap54o58lSLznWRBE/Ph RFSKyVJOIeZhpNC1f1NW46W8g9ybPUHy+GNzmp+ncZUThbg6TZ4DEdEbf/kFTmTY02RJ 6Z5/0GCts38mNtTKmD3fH/+QTMXnqDDvayFh7s/+5z2PGCJXu/Vxid2LSjMsQPppCcaa v+Cef2LQCIyQpHFNRVGwZ9BHVoXnYC464Q5HdRvt8zrOZ9h9PqHaPzF1bHA3sbQYsOFc q/wsb/zonE9veysbO65FnjPepsCLVvPels4I0390EzuqJISPMLB88odpcNaEkWKfrvzv bPbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references :comments:mime-version:content-id:content-transfer-encoding:date :message-id; bh=sG42hDNfb48CqwVntJcMfo+6b55nYPV47L8EMDkRlXk=; b=juGes1WTWFMTqXderagfuUddSRocMFeJKJmZeONa1T1Jpi/uqH7u6lx5IVNclm6Uqf Vefd80ST1kvMkxFB1gj//8fyZWtuOA2xiKlJBTt8j2WdRlqAzyQIeCz6vs8IGfdsB1zk La5HZYDtMEzlKkSc5Y+j8iOPELHMlWFskbFBy6eETb6Lqax0Mr/jKh8IaRCjUtTHHlJ+ CQb5ROY4bwZpNyZtVROEHHRolEiEyze73a6lFRmyq9FKlutLsGGE0vv4sfIoKcQvLb3W /+4SrJBAKJasL4CX8Fc+KVikVx0qLl7quoH536Xes9y1FicWCPH2of9StYOk7/qYMrqR HIcA== X-Gm-Message-State: APjAAAW1hmAkgLbEz7Ux56x4Uh0c4IpT2ZbCUyb+boVhB4BCB7NSU7RE k4pXuoP7BPXYIyP1SnxtPMmH4A== X-Google-Smtp-Source: APXvYqxkmv9vqMMh4cOYdJO/kod5PheIFTf4l2oMDq/IJj1ZhunBh0GT0/lEdB5gFP+hEcao4lyELA== X-Received: by 2002:a05:6000:14d:: with SMTP id r13mr23113485wrx.136.1567572939005; Tue, 03 Sep 2019 21:55:39 -0700 (PDT) Received: from antos ([77.87.240.5]) by smtp.gmail.com with ESMTPSA id f6sm35954067wrh.30.2019.09.03.21.55.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 03 Sep 2019 21:55:38 -0700 (PDT) From: Antonin Houska To: Alvaro Herrera cc: Shawn Wang , pgsql-hackers@lists.postgresql.org, Ants Aasma Subject: Re: WIP: Data at rest encryption In-reply-to: <20190903165615.GA16727@alvherre.pgsql> References: <20190903165615.GA16727@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Tue, 03 Sep 2019 12:56:15 -0400." X-Mailer: MH-E 8.6+git; nmh 1.7; GNU Emacs 26.2.50 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <64820.1567572978.1@antos> Content-Transfer-Encoding: quoted-printable Date: Wed, 04 Sep 2019 06:56:18 +0200 Message-ID: <64821.1567572978@antos> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alvaro Herrera wrote: > On 2019-Aug-02, Shawn Wang wrote: > = > > Hi Antonin, > > It is very glad to see the new patch. I used the public patches a long= time ago. > > I did some tests like the stream replication, much data running, tempo= rary files encryption. > > I found that there is an issue in the src/backend/storage/file/encrypt= ion.c. You should put block_size =3D EVP_CIPHER_CTX_block_size(ctx); under= the #ifdef USE_ASSERT_CHECKING. > > There is some problem to merge your patches to the latest kernel in th= e pg_ctl.c. > = > Is a new, fixed version going to be posted soon? It's been a while. > = > Also, apologies if this has been asked before, but: how does this patch > relate to the stuff being discussed in > https://postgr.es/m/031401d3f41d$5c70ed90$1552c8b0$@lab.ntt.co.jp ? This thread started later than our effort but important design questions a= re being discussed there. So far there seems to be no consensus whether full-instance encryption should be implemented first, so any effort spent = on this patch might get wasted. When/if there will be an agreement on the des= ign, we'll see how much of this patch can be used. -- = Antonin Houska Web: https://www.cybertec-postgresql.com