Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group