Unknown in place of application name

From: amandeep singh <singh_a(at)live(dot)in>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Unknown in place of application name
Date: 2017-08-07 13:41:07
Message-ID: MA1PR01MB07480FE7B96415A8F94CA95D80B50@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-08-07 14:31:14 Re: Unknown in place of application name
Previous Message Evan Rempel 2017-08-07 01:35:47 Re: Logging: stderr vs syslog?