Re: log_hostname and pg_stat_activity
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Steve Singer <ssinger_pg@sympatico.ca>, pgsql-hackers@postgresql.org
Date: 2011-01-30T21:30:05Z
Lists: pgsql-hackers
On sön, 2011-01-30 at 15:03 -0500, Robert Haas wrote: > On Tue, Jan 18, 2011 at 7:24 PM, Steve Singer > <ssinger_pg@sympatico.ca> wrote: > > If my connection is authorized through a line in pg_hba that uses > > client_hostname then the column shows what I expect even with > log_hostname > > set to off. > > > > However if I connect with a line in pg_hba that matches on an IP > network > > then my client_hostname is always null unless log_hostname is set to > true. > > This is consistent with the behavior you describe but I think the > average > > user will find it a bit confusing. > > I agree. I'm not sure there's enough value to this feature to warrant > the amount of user confusion this is likely to produce. What alternative behavior would you suggest?