Re: log_hostname and pg_stat_activity
Magnus Hagander <magnus@hagander.net>
From: Magnus Hagander <magnus@hagander.net>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2010-12-23T21:21:20Z
Lists: pgsql-hackers
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/