Re: log_hostname and pg_stat_activity
| От | Magnus Hagander |
|---|---|
| Тема | Re: log_hostname and pg_stat_activity |
| Дата | |
| Msg-id | AANLkTinqTE_=QLHwiG0Qd4EACw9bigOZMRS8z0KjHirc@mail.gmail.com обсуждение исходный текст |
| Ответ на | log_hostname and pg_stat_activity (Peter Eisentraut <peter_e@gmx.net>) |
| Ответы |
Re: log_hostname and pg_stat_activity
|
| Список | 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/
В списке pgsql-hackers по дате отправления: