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.96) (envelope-from ) id 1vuaCi-00EY5o-0E for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Feb 2026 17:58:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vuaCg-00EXG9-32 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Feb 2026 17:58:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from <9erthalion6@gmail.com>) id 1vuaCg-00EXFz-1s for pgsql-hackers@lists.postgresql.org; Mon, 23 Feb 2026 17:58:42 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from <9erthalion6@gmail.com>) id 1vuaCd-00000000u9Y-1UzQ for pgsql-hackers@postgresql.org; Mon, 23 Feb 2026 17:58:42 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-b79f8f7ea43so762059466b.2 for ; Mon, 23 Feb 2026 09:58:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771869519; x=1772474319; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=h7psGBqIvX8UGGHvwSL5xtaZ91lj7PTIiwRParX0OwE=; b=Sf5tlsyVXs8k1b28+1FYytTwEnkK2tgSWXX5xmlD3GJ6c/I4M+aJqiPyC1sIlyWVqn 5VJkscrgnHoEV7A3sbkIzL6uxVgVja+S/CMK7uzHHQEdo6kQXVE+27PSv9LwanA9OfNz Ut+er1xxJiStP3HEUtBX+H3HDatAMCed7SC5n1/HF+8xtLhtS3X+ITGwqu/cdml095Wr yPsFB+CLcqzYZNz3m9OcaimqNGFQtly33MTQ9fjuGff3Qd7hosI2D3r+V1z55vd+Txgi 23vxf3dmrLdWxRsXuF9HRTZjEWKirtFYJQ5WTBEc0gFENyGosiTgT9ODsYnuBDAKUC0k FNGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771869519; x=1772474319; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=h7psGBqIvX8UGGHvwSL5xtaZ91lj7PTIiwRParX0OwE=; b=QMaHcBIsZguUC6L80ib0bUIjKj0HMiHylT5OqTJAjP/K778ASCYBsuJr++5q+4lX/5 9jYFI5M1D4qeQz295IOWGaPh/QcgzqTFZPXZsm7+CH0Hg4aNX/DArKzKWgD8AVgaSd/w Eo2gJe32mZEHH5t3aCAaG02Wp2zquBtLR1Swp+p/rWRPTsh7Lv2i63I2e6Oj7aJxo/qB UeCOqVKZebSlVEfRIlar0gH16mmpjEln/NJ/ZrUmxlhI9gWIkiNpNrVU/jjOd19HHRyu RiZqiHt3JXwuU/KUpPpT9/DVPmfKu3Ud00DcHuHRR1Yro+y7A8G/Io2WqDcsSB7SDTZU FHYA== X-Forwarded-Encrypted: i=1; AJvYcCUmNKDAnOyonW3JBfBUc1kxfQB/k1MoJgC8KzUMJyNWh+gkMw6iIjAhH70ygCKSWlO27bQgaBKB6rjYjinP@postgresql.org X-Gm-Message-State: AOJu0YzCnk7mACDO3ERgcmvrQOvVeKayguzKd5iVXIPTf0ZteZvb3/Gq OC2NOTsq2RcG60/KSXfKAAvbF5yaE5QvuyRflK43d/C1lZGGGyJ0iHWP X-Gm-Gg: ATEYQzyHbu/mJAaUQVfs7p1FPLAMz4UWBqWfqCmQOCYCoFQbgF2dtRbGi1Qro5ltsts Q03PGbu5pn+n9Bkomkm0ydWf9tRZGxMf8Kz21GWBuhe9BtkA4OyrJq8ohnM0zO46QXgSthW2Cme xvSAnxKkGGSnj0NXDkinWyZFPesr9qsl7DkMIyVOMyQpICZHJF/se5kSQOjArR3S/U5pppRdEY/ zdneNZVERAh4z6SQrI7HeSb0pzdv8VoRTBaeziWSNiNR+OMrffq+XvgDTELBgIHp/uisaCkJzms 9VG2v65Thtfg/UIJJpUoYPICiIusvSArlp9lF0dg8F/YdqAtu14u4acOFikS9H0J5Qf5niDQhJr be9dVD53Dqcs973c1sq5TXbcWS7ruzz0P3TN4Nt1Tma1CgjHqBo6Y8xrN4FS5A8mH/7PpHxRKuS pIUiFHfBfYCZ+9cPY52WozuXgjp86XMAWZYrxzE/nP00rhhbUAuHV3EkuGqQ== X-Received: by 2002:a17:906:9f85:b0:b8e:36ec:88db with SMTP id a640c23a62f3a-b9081a40e99mr570036266b.22.1771869518391; Mon, 23 Feb 2026 09:58:38 -0800 (PST) Received: from ddolgov-thinkpadt14sgen1.rmtde.csb ([2a00:20:637c:9b30:17d9:e5b1:30f1:94df]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b9084f191b9sm339305566b.67.2026.02.23.09.58.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 23 Feb 2026 09:58:37 -0800 (PST) Date: Mon, 23 Feb 2026 18:58:35 +0100 From: Dmitry Dolgov <9erthalion6@gmail.com> To: Jacob Champion Cc: Daniel Gustafsson , PostgreSQL Hackers Subject: Re: Add ssl_(supported|shared)_groups to sslinfo Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Mon, Feb 23, 2026 at 08:48:02AM -0800, Jacob Champion wrote: > On Mon, Feb 23, 2026 at 6:32 AM Daniel Gustafsson wrote: > > +CREATE FUNCTION ssl_shared_groups() RETURNS text > > I don't feel strongly about this, so feel free to disregard: Is there > a reason this API is focusing on the shared group list as opposed to > the actual negotiated group in use? The latter seems more widely > useful to me, and it'd match up with ssl_cipher(). (Or maybe we > already have the negotiated group somewhere and I just never noticed?) No deep reason, it was just useful for some particular experiments and for gathering understanding of what's going on. Would you find it reasonable to have both, shared groups and the negotiated group, or having only the latter is strictly better?