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 1q1CHi-0006B3-JG for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 20:37:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1CHh-00010O-3J for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 20:37:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1CHg-0000zT-Oq for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 20:37:36 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q1CHd-001Uv7-NX for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 20:37:36 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-561d611668eso83399147b3.0 for ; Mon, 22 May 2023 13:37:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684787852; x=1687379852; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=ntTkGUGOhnGb2IIiNoXXrOJIl4bh+CRHXQ6Xnz22hFk=; b=Xu2OJyAm5ENl5+rK9Nf23uBDnELr0RRgYahdsFX+6E49p5C95tWOaZmrYxWx3sC/Ek E2PNmxApHXlkEtXlwtRl4JBvnoBApSYAQqx4hyX5U5GtRYB7Mbo3P2zrge9DSxpt39KZ j6jk+vi7w8dzgCywmLQC4nF/dQtQG4sVAqYCEE4bE7pSWZun8EYOfuS/xD3xYiCX5OFj uAt/kjqjMILf38Fzdt90phkCKlX5AnwEyuozuXWIP+HXhBjrqWUUgqBkAp2P5ADs+6LP 5ovQs65+2HkqZDUIuAZJOUXotINhEVwfDWF8Kzu8NnVX8qnJdQky9iKDbRRNE2uR0Kv6 vrJg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684787852; x=1687379852; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ntTkGUGOhnGb2IIiNoXXrOJIl4bh+CRHXQ6Xnz22hFk=; b=M5D7IXqZmh5uYZRiih6SKv+Nt50sPbnGaKpOdxeagalg+cbouEq8D6czAht5eS7QUR HU0IB0aD4dTbwtUNaFvhLuVPOxeI6hxM+5C7E/a6aVIE0PbQGPjabS/cK9ETwzb8NmUM 5EqXmX7VYeXAymS12/mFy65cwAEWiwMsywQ2MDVE6xfLGj2MVSgMq6PaHwDtUeFffbMG VIckwzbFicIP9sGsn9Cy4TXwEo3gNgz9+VQyURN9tVsE9O+T3e8LxcQFBgoPW+o1o3L0 8jBq8DNbkx2pdnZIykSj5LASeU7ck8sG7bipLjUttk97GgtzppJuGMoYf6Bh0LOvq2MZ AC6w== X-Gm-Message-State: AC+VfDy9TQ3ynzZMUK5tHmcKod1woWhCuiqZ1dzdc3Bw+VpIm0abeX4x kSyKSW42Rw7eO3o4uDP6J47xn0RD4Vg= X-Google-Smtp-Source: ACHHUZ4oUFabvygbRG+Irmr95J96LEgOvUoC3/FMi78fwWl3GEmR9oE9jE8MbHOBz6D3lUT/nvH9yA== X-Received: by 2002:a81:8304:0:b0:555:cee3:d143 with SMTP id t4-20020a818304000000b00555cee3d143mr11924735ywf.4.1684787852560; Mon, 22 May 2023 13:37:32 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:6922:b189:696b:eba2? ([2600:1700:bd2c:b810:6922:b189:696b:eba2]) by smtp.googlemail.com with ESMTPSA id n80-20020a0dcb53000000b0055a373a7e5asm2325850ywd.131.2023.05.22.13.37.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 22 May 2023 13:37:32 -0700 (PDT) Message-ID: Date: Mon, 22 May 2023 15:37:29 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <08c133e0-b136-ff80-886e-b0d4f621c75c@gmail.com> <1d0735cf-b5dd-1c05-d03a-9b52ee2cc5bb@gmail.com> <5d617fb4-a2de-f6a2-f0d3-8a068ac4d83f@aklaver.com> <78CFAEC1-8D31-4CF6-AAFE-AE6C34AD0F42@thebuild.com> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/22/23 15:06, Adrian Klaver wrote: > On 5/22/23 12:38, Ron wrote: >> On 5/22/23 14:22, Tony Xu wrote: > >> RDS Postgresql would do the job just fine.  And since you can't get to >> the files (only access it via port 5432 and aws cli/web, there's no need >> for TDE. > > As I understand TDE whether you can get to the files is not really the > point. It is that someone/thing can and if they do the files are > encrypted. Pretty sure RDS is not magical enough to have no access from > any source to the file system. They sure hide the raw files well, only allowing access from very restricted paths (port Or maybe we just locked it down tight. -- Born in Arizona, moved to Babylonia.