pg_stat_activity.client_addr sometimes null for host connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux