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?