pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Unknown in place of application name 2+ messages / 2 participants [nested] [flat]
* Unknown in place of application name @ 2017-08-07 13:41 amandeep singh <singh_a@live.in> 0 siblings, 1 reply; 2+ messages in thread From: amandeep singh @ 2017-08-07 13:41 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Unknown in place of application name @ 2017-08-07 14:31 Tom Lane <tgl@sss.pgh.pa.us> parent: amandeep singh <singh_a@live.in> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2017-08-07 14:31 UTC (permalink / raw) To: amandeep singh <singh_a@live.in>; +Cc: 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 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-08-07 14:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-08-07 13:41 Unknown in place of application name amandeep singh <singh_a@live.in> 2017-08-07 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>
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