RE: Psql meta-command conninfo+
От | Maiquel Grassi |
---|---|
Тема | RE: Psql meta-command conninfo+ |
Дата | |
Msg-id | CP8P284MB24963D11AD78926C02F22853EC4B2@CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: Psql meta-command conninfo+ (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Список | pgsql-hackers |
>Hmm, I noticed that this would call printSSLInfo() and printGSSInfo()
>after listConnectionInformation. It would be much better to show these
>in tabular format as well and remove the calls to printSSL/GSSInfo.
>
>I propose additional columns to the same \conninfo+ table; when SSL,
>like this:
>
>Database | postgres
>[...]
>Host | 127.0.0.1
>Encryption | SSL
>Protocol | PQsslAttribute(protocol)
>Cipher | PQsslAttribute(cipher)
>Compression | PQsslAttribute(compression)
>
>When GSS, like this
>
>Database | postgres
>[...]
>Host | 127.0.0.1
>Encryption | GSS
>
>(why don't we print anything else in printGSSInfo()? That's weird.)
--//--
Hi Álvaro,
Thank you for the suggestion. I will remove printSSLInfo() and printGSSInfo() and
incorporate the suggested fields into the tabular result of "\conninfo+".
If it's necessary to adjust printGSSInfo(), we can work on that as well. At first
glance, I leave it open for others to analyze and give their opinion.
I'd also like to ask for help with a difficulty. Currently, I'm working on
resolving this situation (highlighted by Pavel Luzanov). How can we
make \conninfo
return the same message as \conninfo+
after closing
the current session in another session with pg_terminate_backend(pid)
?
[postgres@localhost bin]$ ./psql
Tks a lot!
Maiquel Grassi.
В списке pgsql-hackers по дате отправления: