On Thu, Dec 23, 2010 at 22:09, Peter Eisentraut <peter_e@gmx.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/