> On May 4, 2023, at 6:19 AM, Erik Wienhold <ewie@xxxxxxxxx> wrote: > > 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 > > Are those local connections, as those will not have a client_addr? What does your pg_hba look like?
