Em 20 de junho de 2016 18:24, Anderson Cristian <[email protected]>
escreveu:

> log_line_prefix = '%t [%p-%l] %q%u@%d '
>


Conforme a doc[1], o parametro que mostra o host é o `%h`. Caso a conexão
estiver valendo, tu pode pegar e filtrar ela na view pg_stat_activity[2].

[1]
https://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-LINE-PREFIX
[2]
https://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW



-- 
Sebastian Webber
http://swebber.me
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a