From: amandeep singh <singh_a@live.in>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Unknown in place of application name
Thread-Topic: Unknown in place of application name
Thread-Index: AQHTD4Didh7w31hCCEqKzWGcpCdMdA==
Date: Mon, 7 Aug 2017 13:41:07 +0000
Message-ID: 
 <MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [qwYx07oerojUQQlJqKDGhesJ8nGbUWiJ]
x-ms-publictraffictype: Email
x-microsoft-exchange-diagnostics: 
 1;HK2APC01HT037;7:XqETZfrfG0+YPHU3Suh5EKN1avAqC6wOfJ4E4WalCg8RtT6e7I3AIUAyhCika2IcYZ6DDbzFuuWFpMQEemYwC1HxDq9H7kYz0YlpouJ3aAIQ781mwKfaJIpYmJIev1+MgdtDngdNp+Z+e7Htu3o2LwL6qhNn4h+UmwxTZ9UkBWsWeXw1eovZx/HW2MCSxizU6U1Vwkjp+oOBz9UNDYwodaG1MIu9QdSfS+yPNqo1zyaZyRWBnl5gzn3zQvh1PsVuHyFb5u+NfKPBZvbcnUHV2aaEvoKp4Du16SQG0fL55kP1OnNkUiNpr85DZx87OTUe7opS2QWIUz6b0xTl6UDE1bf3JOOx/WaXyxJyGtY+azP4FAmrcL7Y81PQQaraxIHdB0/c0y8b4g8QkpMyvjYfzlqnanA81y0lRzxeajadyKAauZQbvNZDd5r/r5Odl8VriGUy1SWKLafUUOXh2POc3j1v0eU+KXyGtYh+YbFtM/y5XjbZjffwD7SpDkfNI1EUNNvM0M5+xMZ/plN4SE1zVZfEglrnE7iK1AYc5iCcEMfhWLq+56nP4KdpO+Xd3xGuzXTXOqcyTvoq2H0HCr//3EINI3s9agMDMEyst6XR2o39VopIN6KE6jH9kAmvt5oXsZLAKRUZebe7W4SnFk0Y9c2f+C7rvHgVLhtZqWfykOPI4z9r8cYIsHEaBzxV/wQ62oVZYKXNkQ/ve+LuccjbGbSaAIz5/mzUFwsOVIyAHmA97JgxiaN6x2Jqen1kWPiZLteWovhRpVip3OkOumSxdQ==
x-incomingheadercount: 44
x-eopattributedmessage: 0
x-forefront-antispam-report: 
 EFV:NLI;SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:HK2APC01HT037;H:MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en;
x-ms-office365-filtering-correlation-id: b3002bac-9598-4915-67f1-08d4dd99f52e
x-microsoft-antispam: 
 UriScan:;BCL:0;PCL:0;RULEID:(300000500095)(300135000095)(300000501095)(300135300095)(22001)(300000502095)(300135100095)(300000503095)(300135400095)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322377)(1603101448)(1601125374)(1701031045)(300000504095)(300135200095)(300000505095)(300135600095)(300000506095)(300135500095);SRVR:HK2APC01HT037;
x-ms-traffictypediagnostic: HK2APC01HT037:
x-exchange-antispam-report-test: UriScan:(278428928389397);
x-exchange-antispam-report-cfa-test: 
 BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(444000031);SRVR:HK2APC01HT037;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:HK2APC01HT037;
x-forefront-prvs: 0392679D18
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_MA1PR01MB07480FE7B96415A8F94CA95D80B50MA1PR01MB0748INDP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Aug 2017 13:41:07.6307
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Internet
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: HK2APC01HT037
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--_000_MA1PR01MB07480FE7B96415A8F94CA95D80B50MA1PR01MB0748INDP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All


I have enabled logging parameters in PostgreSQL 9.6.


log_line_prefix =3D %t %a

log_connection =3D on

log_disconnection =3D on


 After enabling I have checked the log and found that all new connections a=
re showing unknown for application name however it is showing application n=
ame in disconnection. Same is tested with multiple applications and getting=
 same result.


2017-08-07 18:55:44 IST [[unknown]] LOG:  connection received: host=3D[loca=
l]
2017-08-07 18:55:48 IST [[unknown]] LOG:  connection received: host=3D[loca=
l]
2017-08-07 18:55:48 IST [[unknown]] LOG:  connection authorized: user=3Dpos=
tgres database=3Dpostgres
2017-08-07 18:55:54 IST [psql.bin] LOG:  disconnection: session time: 0:00:=
06.004 user=3Dpostgres database=3Dpostgres host=3D[local]


Kindly suggest.


Thanks and Regards:
Amandeep Singh

--_000_MA1PR01MB07480FE7B96415A8F94CA95D80B50MA1PR01MB0748INDP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" dir=3D"ltr" style=3D"font-size: 12pt; colo=
r: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, Em=
ojiFont, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, NotoCol=
orEmoji, &quot;Segoe UI Symbol&quot;, &quot;Android Emoji&quot;, EmojiSymbo=
ls;">
<p>Hi All</p>
<p><br>
</p>
<p>I have enabled logging parameters in&nbsp;<span style=3D"font-family: Ca=
libri, Helvetica, sans-serif, Helvetica, EmojiFont, &quot;Apple Color Emoji=
&quot;, &quot;Segoe UI Emoji&quot;, NotoColorEmoji, &quot;Segoe UI Symbol&q=
uot;, &quot;Android Emoji&quot;, EmojiSymbols; font-size: 16px;">PostgreSQL=
 9.6.</span></p>
<p><span style=3D"font-family: Calibri, Helvetica, sans-serif, Helvetica, E=
mojiFont, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, NotoCo=
lorEmoji, &quot;Segoe UI Symbol&quot;, &quot;Android Emoji&quot;, EmojiSymb=
ols; font-size: 16px;"><br>
</span></p>
<p>log_line_prefix =3D<span>&nbsp;%t %a&nbsp;</span></p>
<p>log_connection =3D on</p>
<p><span style=3D"font-size: 12pt;">log_disconnection =3D on</span></p>
<p><span style=3D"font-size: 12pt;"><br>
</span></p>
<p><span style=3D"font-size: 12pt;">&nbsp;After enabling I have checked the=
 log and found that all new&nbsp;connections are showing unknown for applic=
ation name&nbsp;however it is showing application name in disconnection. Sa=
me is tested with multiple applications and getting
 same result.</span><br>
</p>
<p><span style=3D"font-size:12pt"><br>
</span></p>
<p><span style=3D"font-size:12pt"></span></p>
<div>2017-08-07 18:55:44 IST<b> [[unknown]]</b> LOG: &nbsp;connection recei=
ved: host=3D[local]</div>
<div>2017-08-07 18:55:48 IST <b>[[unknown]] </b>LOG: &nbsp;connection recei=
ved: host=3D[local]</div>
<div>2017-08-07 18:55:48 IST <b>[[unknown]]</b> LOG: &nbsp;connection autho=
rized: user=3Dpostgres database=3Dpostgres</div>
<div>2017-08-07 18:55:54 IST<b> [psql.bin] </b>LOG: &nbsp;disconnection: se=
ssion time: 0:00:06.004 user=3Dpostgres database=3Dpostgres host=3D[local]<=
/div>
&nbsp;
<p></p>
<p><span style=3D"font-size:12pt">Kindly suggest.</span></p>
<p><br>
</p>
<div id=3D"Signature">Thanks and Regards:
<div>Amandeep Singh</div>
</div>
</div>
</body>
</html>

--_000_MA1PR01MB07480FE7B96415A8F94CA95D80B50MA1PR01MB0748INDP_--