Обсуждение: [MASSMAIL]Adding application_name to the error and notice message fields
Hi! We take care to always set application_name to improve our log lines where we use %a in log_line_prefix to log application name, per [1]. But notices which are sent to the client do not have the application name and are thus hard to attribute correctly. Could "a" be added with the application name (when available) to the error and notice message fields [2]? Mitar [1] https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LINE-PREFIX [2] https://www.postgresql.org/docs/current/protocol-error-fields.html -- https://mitar.tnode.com/ https://twitter.com/mitar_m https://noc.social/@mitar
Hi! Oh, I can use PQparameterStatus to obtain application_name of the current connection. It seems then it is not needed to add this information into notice message. Mitar On Wed, Mar 27, 2024 at 4:22 PM Mitar <mmitar@gmail.com> wrote: > > Hi! > > We take care to always set application_name to improve our log lines > where we use %a in log_line_prefix to log application name, per [1]. > But notices which are sent to the client do not have the application > name and are thus hard to attribute correctly. Could "a" be added with > the application name (when available) to the error and notice message > fields [2]? > > > Mitar > > [1] https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LINE-PREFIX > [2] https://www.postgresql.org/docs/current/protocol-error-fields.html > > -- > https://mitar.tnode.com/ > https://twitter.com/mitar_m > https://noc.social/@mitar -- https://mitar.tnode.com/ https://twitter.com/mitar_m https://noc.social/@mitar