From: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> |
---|---|
To: | Hunaid Sohail <hunaidpgml(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)postgresql(dot)org, Maiquel Grassi <grassi(at)hotmail(dot)com(dot)br>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Erik Wienhold <ewie(at)ewie(dot)name> |
Subject: | Re: Psql meta-command conninfo+ |
Date: | 2024-09-30 18:16:09 |
Message-ID: | 6f0a9200-215d-4cbd-9577-a3d4a6da1487@uni-muenster.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
On 26.09.24 09:15, Hunaid Sohail wrote:
> This patch renames "Current User" to "Authenticated User" as suggested
> by me in my last email. I have also updated the documentation accordingly.
Could you perhaps in the documentation elaborate a bit more on the
difference between "Current User" and "Authenticated User"? IMHO a
couple of words on how exactly they differ would be very helpful, as
they show the same user in many cases.
> Authenticated User: The name of the user returned by PQuser()
> Session User: The session user's name.
Although a bit redundant, I'd argue that "SSL Compression" is better
than just "Compression".
Other than that, it looks much better now:
$ /usr/local/postgres-dev/bin/psql -x "\
host=server.uni-muenster.de
hostaddr=192.168.178.27
user=jim dbname=db
port=54322
sslmode=verify-full
sslrootcert=server-certificates/server.crt
sslcert=jim-certificates/jim.crt
sslkey=jim-certificates/jim.key"
psql (18devel)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384,
compression: off, ALPN: postgresql)
Type "help" for help.
db=# SET client_encoding TO 'LATIN1';
SET
db=# \conninfo+
Connection Information
-[ RECORD 1 ]--------+-----------------------
Database | db
Authenticated User | jim
Session User | jim
Host | server.uni-muenster.de
Host Address | 192.168.178.27
Port | 54322
Protocol Version | 3
SSL Connection | true
SSL Protocol | TLSv1.3
SSL Cipher | TLS_AES_256_GCM_SHA384
Compression | off
ALPN | postgresql
GSSAPI Authenticated | false
Client Encoding | LATIN1
Server Encoding | UTF8
Backend PID | 874890
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2024-09-30 18:33:30 | Re: Inconsistency in reporting checkpointer stats |
Previous Message | Daniel Westermann (DWE) | 2024-09-30 17:56:51 | Re: pg_basebackup and error messages dependent on the order of the arguments |