On 28.02.22 16:12, Tom Lane wrote:
Daniel Gustafsson <dan...@yesql.se> writes:
On 28 Feb 2022, at 12:56, Peter Eisentraut <peter.eisentr...@enterprisedb.com> 
wrote:
On 28.02.22 11:50, Dagfinn Ilmari Mannsåker wrote:
How about making it show "compression: on" if compression is on, but
nothing in the common "off" case?

That would work for me.

On POLA grounds I would prefer to never to show it.  If we ever get libpq
compression and want to show that, I'd prefer that we didn't end up
"compression" meaning one thing except when it means two things.

Well, any such output would presumably be on a different line and
thus distinguishable from the SSL property; plus, it'd be impossible
for both forms to show up in the same connection.

However, how about writing "SSL compression: on" versus writing
nothing?  That avoids doubt about what it means.  I don't buy
Michael's argument that this is ambiguous, either.

I didn't mean to reopen the whole SSL compression can of worms here, I was mistaken about the level of support left after PG14. I was merely lightly annoyed that the psql startup display got quite long with not very interesting information.

I propose a reduced patch that just removes the "bits" display, since that is redundant with the "cipher" display.
From 9768dc5ab9a01a60e899bfc5c9e1a51475ded183 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <pe...@eisentraut.org>
Date: Tue, 1 Mar 2022 09:38:38 +0100
Subject: [PATCH v2] psql: Make SSL info display more compact

Remove the bits display, since that can be derived from the cipher
suite.
---
 src/bin/psql/command.c | 5 +----
 1 file changed, 1 insertion(+), 4 deletions(-)

diff --git a/src/bin/psql/command.c b/src/bin/psql/command.c
index 292cff5df9..079f4a1a76 100644
--- a/src/bin/psql/command.c
+++ b/src/bin/psql/command.c
@@ -3667,7 +3667,6 @@ printSSLInfo(void)
 {
        const char *protocol;
        const char *cipher;
-       const char *bits;
        const char *compression;
 
        if (!PQsslInUse(pset.db))
@@ -3675,13 +3674,11 @@ printSSLInfo(void)
 
        protocol = PQsslAttribute(pset.db, "protocol");
        cipher = PQsslAttribute(pset.db, "cipher");
-       bits = PQsslAttribute(pset.db, "key_bits");
        compression = PQsslAttribute(pset.db, "compression");
 
-       printf(_("SSL connection (protocol: %s, cipher: %s, bits: %s, 
compression: %s)\n"),
+       printf(_("SSL connection (protocol: %s, cipher: %s, compression: 
%s)\n"),
                   protocol ? protocol : _("unknown"),
                   cipher ? cipher : _("unknown"),
-                  bits ? bits : _("unknown"),
                   (compression && strcmp(compression, "off") != 0) ? _("on") : 
_("off"));
 }
 

base-commit: a33e17f210547226ada52d2b8af851c3553bb4fa
-- 
2.35.1

Reply via email to