From: amandeep singh <singh_a@live.in>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Unknown in place of application name
Date: Mon, 7 Aug 2017 13:41:07 +0000
Message-ID: <MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi All
I have enabled logging parameters in PostgreSQL 9.6.
log_line_prefix = %t %a
log_connection = on
log_disconnection = on
After enabling I have checked the log and found that all new connections are showing unknown for application name however it is showing application name in disconnection. Same is tested with multiple applications and getting same result.
2017-08-07 18:55:44 IST [[unknown]] LOG: connection received: host=[local]
2017-08-07 18:55:48 IST [[unknown]] LOG: connection received: host=[local]
2017-08-07 18:55:48 IST [[unknown]] LOG: connection authorized: user=postgres database=postgres
2017-08-07 18:55:54 IST [psql.bin] LOG: disconnection: session time: 0:00:06.004 user=postgres database=postgres host=[local]
Kindly suggest.
Thanks and Regards:
Amandeep Singh
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: singh_a@live.in
Subject: Re: Unknown in place of application name
In-Reply-To: <MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM>
* 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