public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: Sami Imseih <[email protected]>
Cc: Hunaid Sohail <[email protected]>
Cc: [email protected]
Cc: David G. Johnston <[email protected]>
Cc: Maiquel Grassi <[email protected]>
Cc: Jim Jones <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Nathan Bossart <[email protected]>
Cc: Imseih (AWS), Sami <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Pavel Luzanov <[email protected]>
Cc: Erik Wienhold <[email protected]>
Cc: Dean Rasheed <[email protected]>
Subject: Re: Psql meta-command conninfo+
Date: Mon, 20 Jan 2025 12:40:03 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAA5RZ0uFqSxUbY67rFUX6+32Y384fzMigN7ybQ=orvQOquBLDA@mail.gmail.com>

On 2025-Jan-17, Sami Imseih wrote:

> > Wait a second, why do we have these here?  Aren't they already in
> > \dconfig?
> 
>  \dconfig is generated by querying pg_settings and this
> requires a halthy connection. The parameters being proposed with
> \conninfo+ are set in libpq by the server [1] and can be retrieved
> even if the connection breaks.
> 
> Some of these parameters may overlap \dconfig, but I don't see
> that as a problem.

I feel the need to step back and ask, what problem are we solving here?
Your explanation isn't wrong, but I'm not sure why does a psql user need
all these.

I think you wanted to display "is_superuser" and that seems sensible in
the context of \conninfo+, and perhaps even "role" and "in_hot_standby"
would make sense; but the rest of the parameters that libpq stores do
not seem terribly interesting or relevant here.


That leads me to also wonder why don't we change \conninfo to have this
tabular behavior instead of creating a separate command for it.  Why do
we need to keep the existing form of \conninfo?  To me it seems strictly
less useful, as it is harder to read.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Psql meta-command conninfo+
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox