On 2018-Jun-22, Andres Freund wrote: > On 2018-06-22 15:50:06 -0400, Alvaro Herrera wrote: > > On 2018-Jun-22, Andres Freund wrote: > > > > > On 2018-06-22 15:26:06 -0400, Alvaro Herrera wrote: > > > > On 2018-Jun-22, Andres Freund wrote: > > > > > I think a fair argument could be made that you'd want to have > > > > > application_name logged exactly once, not in every line. Just to cope > > > > > with log volume. With decent log analysis tools once is enough. > > > > > > > > Seems harder than it sounds ... because if the user turns off > > > > log_connections then it's not longer in the log. > > > > > > That's superuser only, so I really don't quite buy that argument. > > > > I meant if the DBA disables it in postgresql.conf then the info is > > nowhere. > > I'm not following - application_name isn't logged anywhere by default > currently either.
Right. I +1'd the proposal to have it in the log_connections line. My mind was wandering about doing more than that (or doing something different), but let's not derail the thread. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
