From: Erik Wienhold <ewie@ewie.name>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: pg_stat_activity.client_addr sometimes null for host connections
Date: Thu, 4 May 2023 12:19:03 +0200 (CEST)
Message-ID: <1123557200.1646445.1683195543242@office.mailbox.org> (raw)
I have a process that regularly queries pg_stat_activity for user connections.
Today I noticed an error because sometimes client_addr is null for some user
connections. pg_hba.conf only allows host connections. So client_addr should
not be null according to [0]. pg_stat_activity is queried as superuser who
should see client_addr for all connections, not just his own.
This is on v12.14 on Windows Server (regular EnterpriseDB install). Is this a
known issue or just an undocumented corner case?
[0] https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
--
Erik
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ewie@ewie.name, pgsql-admin@lists.postgresql.org
Subject: Re: pg_stat_activity.client_addr sometimes null for host connections
In-Reply-To: <1123557200.1646445.1683195543242@office.mailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox