Re: log_hostname and pg_stat_activity

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Steve Singer <ssinger_pg(at)sympatico(dot)ca>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: log_hostname and pg_stat_activity
Date: 2011-01-30 21:30:05
Message-ID: 1296423005.4145.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)sympatico(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2011-01-30 21:33:07 Re: WIP: RangeTypes
Previous Message Magnus Hagander 2011-01-30 20:26:22 Re: Visual Studio 2010/Windows SDK 7.1 support