Capturing both IP address and hostname in the log

From: "Tefft, Michael J" <Michael(dot)J(dot)Tefft(at)snapon(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Capturing both IP address and hostname in the log
Date: 2025-04-10 12:22:16
Message-ID: BN8PR04MB550874EE58EC715656C3D3D2D0B72@BN8PR04MB5508.namprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

The documentation for log_hostname says:
log_hostname (boolean)
By default, connection log messages only show the IP address of the connecting host. Turning this parameter on causes logging of the host name as well. Note that depending on your host name resolution setup this might impose a non-negligible performance penalty. This parameter can only be set in the postgresql.conf file or on the server command line.

https://www.postgresql.org/docs/14/runtime-config-logging.html

We have set log_hostname ON and we get hostname reported - but we do not get IP address. We would like to capture both.
Since the doc says "Turning this parameter on causes logging of the host name *as well*" we were hoping we would capture both, but we are not getting what we expect.

Is there a way to capture both IP address and hostname in the log messages? Or must we choose "one or the ootehr"?

Thanks,
Mike Tefft

(We are using PG14 and PG16, but the docs say the same thing, as does PG17)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Swanhart 2025-04-10 12:28:36 Archive logging not cleaning up pg_wal directory
Previous Message Achilleas Mantzios 2025-04-10 12:17:27 Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-04-10 12:25:24 Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c
Previous Message Heikki Linnakangas 2025-04-10 12:19:37 Re: PostgreSQL 18 Release Management Team & Feature Freeze