pg_stat_activity.client_addr sometimes null for host connections

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pg_stat_activity.client_addr sometimes null for host connections
Date: 2023-05-04 10:19:03
Message-ID: 1123557200.1646445.1683195543242@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-05-04 13:21:50 Re: Just View create privilege to user user2
Previous Message Erik Wienhold 2023-05-04 09:08:50 Re: Just View create privilege to user user2