Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgJKy-00FCAH-AL for pgsql-novice@arkaria.postgresql.org; Wed, 13 Sep 2023 06:26:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qgJKv-00F5bl-Sd for pgsql-novice@arkaria.postgresql.org; Wed, 13 Sep 2023 06:26:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgJKv-00F5bW-J2 for pgsql-novice@lists.postgresql.org; Wed, 13 Sep 2023 06:26:53 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qgJKn-004Hi0-Ux for pgsql-novice@lists.postgresql.org; Wed, 13 Sep 2023 06:26:52 +0000 Received: by mail-ot1-x332.google.com with SMTP id 46e09a7af769-6bf298ef1f5so4437487a34.0 for ; Tue, 12 Sep 2023 23:26:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1694586405; x=1695191205; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Stsy4fUWufR/PDjs+RhYJG11szgnCsUZD0yGX967efM=; b=WM408+zYZxDbQhIrev7nNiEehXAsIuE69mT8eo6MwOgr8gTdqGh3f3ZjgpRCMbxF73 CTn0aYxX1kPD2E/go9MBcaeAZ1p4iGrrhs5wWwdnk3KT02KveH3qwvd6+kVvh4wIuyVL kVGrHLbqvzFROeBtgnAvtCp42kmXw9NYwczl0HrqlwUj8Vn0u2t55EI5po+lKxHMyaNs QhT9RGLr2nW+A+y43ALzQ0z8PjylK2ezfV3tKohDh9BkyKPjn+HsZb7xL0b+AnOFjnRW a3YB63LVnyoq6SOHL2fGufsjYUqCTr7+rC/XIsevG+0/zLOQXOmHw42TRI/eRsj2HHPe Hz+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694586405; x=1695191205; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Stsy4fUWufR/PDjs+RhYJG11szgnCsUZD0yGX967efM=; b=GkS5dGIi+XfUTMki4no49CgiKSp/yK8Zq4YJIdzxZf1F3ES/TknkSa91sDz0d0a/9y FhUcst0TkInCdETVqauLc/q2RLp4zGQU7h/EwIf2j+XHLo8th23eQei16OQrTadxavhK uMuAKVJ9U63dXGXzd64JxIpnSgQWiOefK0+Luy9QnS2h8hPQvyeLcZZ3jZs2D3j7ZLwz ZwGWFjkIORZnyjg63tuJk+avsALQB+bFj3KOet1VkT659Fsdnd58pL5VZJ3E1ixbRzt9 KNgqXslc9AHhNlmBu5zkLQ2IZN+Yb5ePqN0J8eJyKEJGX1oy2fB8hWsU2QrL1tyZ8cpp uoIQ== X-Gm-Message-State: AOJu0Yyd6tVFuqzW49ZqClTPds+Xywl9wBeeFKQJOG6SCyblmuCAW85e As/zxliF4+FMD4fGpNGGh5TkYvpfNfYISavLBcq5p0nmmFOap3I3 X-Google-Smtp-Source: AGHT+IEbam9rmDnJqN+4t5iyJLU3DZfn+cUT0m9ThaRAv3zXNikX/C8Su1pMwIIBOObeZLHfWQmXWlxm90RSuf6if6I= X-Received: by 2002:a05:6358:52d4:b0:134:e964:134c with SMTP id z20-20020a05635852d400b00134e964134cmr2031201rwz.11.1694586404887; Tue, 12 Sep 2023 23:26:44 -0700 (PDT) MIME-Version: 1.0 From: Mingyu Li Date: Wed, 13 Sep 2023 14:26:18 +0800 Message-ID: Subject: Enabling Full Encryption For PostgreSQL To: pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000b45f3e060537a461" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b45f3e060537a461 Content-Type: text/plain; charset="UTF-8" Hi folks, How can a DBA manage a database containing sensitive data without risking data leakage? Our team has developed an extension for PostgreSQL, HEDB ( github.com/SJTU-IPADS/HEDB), which enables SQL computation over encrypted data. We've tested it using Postgres 14.9 on Ubuntu and it can execute TPC-H queries successfully. While I know that this extension has room for improvement, I am eager to learn how to contribute our code to the community. -- With appreciation, Maxul --000000000000b45f3e060537a461 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi folks,

How can= a DBA manage a database containing sensitive data without risking data lea= kage?

Our team has developed an extension for PostgreSQL, HEDB (github.com/SJTU-IPADS/HEDB), = which enables SQL computation over encrypted data. We've tested it usin= g Postgres 14.9 on Ubuntu and it can execute TPC-H queries=C2=A0
successfully.

While I know that this extension has room for = improvement, I am eager to learn how to contribute our code to the communit= y.

--
With appreciation,
Maxul

--000000000000b45f3e060537a461--