Peter Eisentraut <peter_e@gmx.net> writes:
> There are functions pg_stat_get_backend_client_addr and
> pg_stat_get_backend_client_port, which are exposed through the
> pg_stat_activity view, but there is no straightforward way to get the
> server-side address and port of a connection. This is obviously much
> less commonly needed than the client information,
... indeed. Is it worth burdening the pg_stats mechanism with this?
The use case seems vanishingly thin.
regards, tom lane