| From: | "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu> |
|---|---|
| To: | "Artem Tomyuk" <admin(at)leboutique(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [MASSMAIL]custom log. variable %h reports [unknown] |
| Date: | 2016-01-26 18:17:13 |
| Message-ID: | 47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> Hi All!
>
> og_connections = on
>
> log_disconnections = on
>
> log_line_prefix = '===========> %h %u %t %p %x: [%l-1]'
>
> log_hostname = off
>
> But in logs i see:
>
Hello Artem,
Use this: log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u ' --'%t [%p]:
[%l-1] user=%u,db=%d '
> ===========> [*unknown*] 2016-01-26 17:07:46 UTC 1664 0: [1-1]LOG:
> connection received: host=192.168.112.181 port=50321
>
> ===========> 192.168.112.181 postgres 2016-01-26 17:07:46 UTC 1664 0:
> [2-1]LOG: connection authorized: user=postgres database=lb_upr
>
> ===========> [*unknown*] 2016-01-26 17:08:27 UTC 1665 0: [1-1]LOG:
> connection received: host=192.168.112.181 port=50330
>
> The off. docs says that variable %h stands for Remote hostname or IP.
>
> Any ideas?
>
>
> PS
>
> DNS server configured to NOT answer on r-lookup queries, because he does
> not have reverse zone for my network.
>
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2016-01-26 18:19:35 | Re: custom log. variable %h reports [unknown] |
| Previous Message | Artem Tomyuk | 2016-01-26 17:51:26 | custom log. variable %h reports [unknown] |