Re: [ADMIN] iso-8859-1 in place of application name - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] iso-8859-1 in place of application name
Date
Msg-id 23595.1502116274@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] iso-8859-1 in place of application name  (amandeep singh <singh_a@live.in>)
List pgsql-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
howeverit 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


pgsql-admin by date:

Previous
From: amandeep singh
Date:
Subject: [ADMIN] iso-8859-1 in place of application name
Next
From: Sathesh S
Date:
Subject: [ADMIN] Performance impact for enabling Log_disconnections