Re: log_hostname and pg_stat_activity

On Thu, Dec 23, 2010 at 22:09, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Somehow I fantasized that log_hostname would also turn
> pg_stat_activity.client_addr into names instead of IP addresses.  It
> doesn't, but perhaps it should?  It would be nice to be able to
> configure an IP-address free setup.  Or would it be worth having a
> separate configuration parameter for that?

It should certainly be renamed to something else if it does both, but
I don't see the point of having two separate parameters between them.
As long as you can use a cached version of the lookup, you're only
paying the price once, after all...

However, pg_stat_activity.client_addr is an inet field, not a text
string, so you'd have to invent a separate field for it I think...

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/