On Wed, May 18, 2022 at 3:08 AM Dominique Devienne <ddevienne@gmail.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.
AFAIK, it’s not psql that does this though, it’s libpq the official client api.
And the fact libpq has no way to surface that info seems like an important oversight.