pg_stat_activity.client_addr sometimes null for host connections - Mailing list pgsql-admin

From Erik Wienhold
Subject pg_stat_activity.client_addr sometimes null for host connections
Date
Msg-id 1123557200.1646445.1683195543242@office.mailbox.org
Whole thread Raw
Responses Re: pg_stat_activity.client_addr sometimes null for host connections
List 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



pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Just View create privilege to user user2
Next
From: M Sarwar
Date:
Subject: Re: Just View create privilege to user user2