Re: [PATCH] Connection time for \conninfo

On 2020-03-10 18:38, Stephen Frost wrote:
>> On 2/27/20 4:21 AM, Peter Eisentraut wrote:
>>> My opinion is that this is not particularly useful and not appropriate to
>>> piggy-back onto \conninfo.  Connection information including host, port,
>>> database, user name is a well-established concept in PostgreSQL programs
>>> and tools and it contains a delimited set of information. Knowing what
>>> server and what database you are connected to also seems kind of
>>> important.  Moreover, this is information that is under control of the
>>> client, so it must be tracked on the client side.
>
> I have to say that I disagree. Wishing to know when you connected to a
> server is entirely reasonable and it's also rather clearly under control
> of the client (though I don't entirely understand that argument in the
> first place).

The argument is that the server already knows when the client connected
and that information is already available. So there is no reason for
the client to also track and display that information, other than
perhaps convenience. But the server does not, in general, know what
host and port the client connected to (because of proxying and other
network stuff), so this is something that the client must record itself.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services