pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Artem Tomyuk <admin@leboutique.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [MASSMAIL]custom log. variable %h reports [unknown]
Date: Tue, 26 Jan 2016 13:17:13 -0500 (GMT+5)
Message-ID: <47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <CANYYVqJUwtLgG6872XUn=kprifd3J9ZOCBjgTw0HB3npYbG35g@mail.gmail.com>
References: <CANYYVqJUwtLgG6872XUn=kprifd3J9ZOCBjgTw0HB3npYbG35g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (4+ messages)  latest in thread

Message-ID: <47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu>
Permalink:  ../47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu/
Also on:    postgresql.org/message-id/47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gilberto.castillo@etecsa.cu, admin@leboutique.com
  Subject: Re: [MASSMAIL]custom log. variable %h reports [unknown]
  In-Reply-To: <47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox