| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Who am I? Where am I connected? |
| Date: | 2022-05-18 15:43:03 |
| Message-ID: | CAKFQuwZK=Gsuwts9gcje8-vQ8ZXoGcm1CHgo9oVTzowOVKi9TQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 18, 2022 at 3:08 AM Dominique Devienne <ddevienne(at)gmail(dot)com>
wrote:
> Once connected, can I find out all aspects of the connection string?
> Or where they came from, like a pgpass.conf or service file?
>
> How to get the host, port, db name once connected?
> SHOW and pg_settings does not appear to be it, at first glance.
>
>
The server has no clue how the values sent to it came into existence - nor
should it.
Whether and how any particular client might expose this kind of debugging
information (or upgrade it to proper state info) is up to the client. I do
not know what options psql offers.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Koen De Groote | 2022-05-18 20:51:01 | In case of network issues, how long before archive_command does retries |
| Previous Message | Dominique Devienne | 2022-05-18 15:31:19 | Re: Who am I? Where am I connected? |