Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aO8DZ-00081p-7F for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2016 18:19:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aO8DY-0000y7-K6 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2016 18:19:52 +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 1aO8DY-0000y1-1c for pgsql-admin@postgresql.org; Tue, 26 Jan 2016 18:19:52 +0000 Received: from resqmta-ch2-03v.sys.comcast.net ([2001:558:fe21:29:69:252:207:35]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aO8DV-0003DT-86 for pgsql-admin@postgresql.org; Tue, 26 Jan 2016 18:19:50 +0000 Received: from resomta-ch2-11v.sys.comcast.net ([69.252.207.107]) by resqmta-ch2-03v.sys.comcast.net with comcast id AiKd1s0032Ka2Q501iKma6; Tue, 26 Jan 2016 18:19:46 +0000 Received: from jerry.enova.com ([12.30.159.20]) by resomta-ch2-11v.sys.comcast.net with comcast id AiKb1s00c0ShjPw01iKeCN; Tue, 26 Jan 2016 18:19:44 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id B4FA17401EA; Tue, 26 Jan 2016 12:19:35 -0600 (CST) From: Jerry Sievers To: Artem Tomyuk Cc: pgsql-admin@postgresql.org Subject: Re: custom log. variable %h reports [unknown] References: Date: Tue, 26 Jan 2016 12:19:35 -0600 In-Reply-To: (Artem Tomyuk's message of "Tue, 26 Jan 2016 19:51:26 +0200") Message-ID: <86bn88urt4.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1453832386; bh=epa/XBloSNAdYPXKfymT8Z1H6Y+7hfBzLjsG6c++D0w=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=QYbI0MEeHiKlpce37aTcKWn6eO+mwVRDBItZuOaqzGEDxijPSK3R4KBy/omsm/N3E noQdY/wRSXSk8zewp7RWf+OZXBkOaf2XX33y3yB5MJmbeErX9TmcMfi7IHQR36V3Qq QuinaGIOp9yqqOWVWkx+WAuGF1wc13dawItphQSPew97qabQlM0NLTgEUeNqgwmY9c 37A+mmMprmLUmPo0rkpbMA7BQL40X94dD6hZKHuJWBU4xTnH7tSsVN98VbhwVpZCaX zDf1m95W0Q201eeU1VEQLOAl2PPA2vVhV9jQ1JM3JDP9xSUpm34GIPsuaf19cHmbcA 3Pkwr1ydwCpeg== X-Pg-Spam-Score: -1.5 (-) 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 Artem Tomyuk writes: > 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 Postmaster. You should get something similar for AutoVac activity and/or anything else not originated from a particular backend. > ===========> 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. > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin