Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aO8B9-0007vw-5w for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2016 18:17:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aO8B8-0007X3-LZ for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2016 18:17:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aO8B8-0007Wx-7I for pgsql-admin@postgresql.org; Tue, 26 Jan 2016 18:17:22 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aO8B3-0003D8-UX for pgsql-admin@postgresql.org; Tue, 26 Jan 2016 18:17:19 +0000 Received: from mn3.etecsa.cu (unknown [192.168.91.45]) by imx6.etecsa.cu (Postfix) with ESMTP id 71889121 for ; Tue, 26 Jan 2016 13:17:13 -0500 (CST) Received: (qmail 23643 invoked by uid 11185); 26 Jan 2016 18:16:14 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.056296 secs); 26 Jan 2016 18:16:14 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 26 Jan 2016 18:16:14 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Tue, 26 Jan 2016 13:17:13 -0500 (GMT+5) Message-ID: <47016.192.168.207.54.1453832233.squirrel@webmail.etecsa.cu> In-Reply-To: References: Date: Tue, 26 Jan 2016 13:17:13 -0500 (GMT+5) Subject: Re: [MASSMAIL]custom log. variable %h reports [unknown] From: "Gilberto Castillo" To: "Artem Tomyuk" Cc: pgsql-admin@postgresql.org Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 90220 [Jan 26 2016] X-KLMS-AntiSpam-Version: 5.5.6 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Moebius-Timestamps: 3932475, 3932697, 3932486 X-KLMS-AntiSpam-Info: LuaCore: 406 406 5c898342d373668b3b9f614f48d8244d080de696, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2016/01/26 12:51:30 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/01/26 10:22:00 #6861031 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > 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