From: Tom Lane <tgl@sss.pgh.pa.us>
To: amandeep singh <singh_a@live.in>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Unknown in place of application name
Date: Mon, 07 Aug 2017 10:31:14 -0400
Message-ID: <23595.1502116274@sss.pgh.pa.us> (raw)
In-Reply-To: <MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM>
References: <MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
amandeep singh <singh_a@live.in> writes:
> 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]
This is unsurprising: the connection received/authorized messages come
out before absorbing any parameters (such as application_name) from
the connection request packet.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: tgl@sss.pgh.pa.us, singh_a@live.in
Subject: Re: Unknown in place of application name
In-Reply-To: <23595.1502116274@sss.pgh.pa.us>
* 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