| From: | Artem Tomyuk <admin(at)leboutique(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | custom log. variable %h reports [unknown] |
| Date: | 2016-01-26 17:51:26 |
| Message-ID: | CANYYVqJUwtLgG6872XUn=kprifd3J9ZOCBjgTw0HB3npYbG35g@mail.gmail.com |
| 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:
===========> [*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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilberto Castillo | 2016-01-26 18:17:13 | Re: [MASSMAIL]custom log. variable %h reports [unknown] |
| Previous Message | Alvaro Herrera | 2016-01-26 17:37:17 | Re: pg_dump / pg_restore - TOC.dat file |