Re: How to print application_name in log_line_prefix (using %a)? - Mailing list pgsql-general

From Chris Angelico
Subject Re: How to print application_name in log_line_prefix (using %a)?
Date
Msg-id CAPTjJmouu5=Gik5Oo-_g8CDz4CkvMap_V38iJFs+Lgy-Y1Tz-g@mail.gmail.com
Whole thread Raw
In response to Re: How to print application_name in log_line_prefix (using %a)?  (Tianyin Xu <tixu@cs.ucsd.edu>)
Responses Re: How to print application_name in log_line_prefix (using %a)?  (Tianyin Xu <tixu@cs.ucsd.edu>)
List pgsql-general
On Mon, Oct 29, 2012 at 5:22 PM, Tianyin Xu <tixu@cs.ucsd.edu> wrote:
> Thanks a lot, Chris!
>
> Yes, the manual said that "It is typically set by an application upon
> connection to the server." exactly your approach.
>
> But the examples you gave me is to print the application_name in the query
> results, aren't they? Do you know how to make it as the prefix of the local
> log messages?

The examples I gave configure the application_name for a given
connection. Everything that connection does will then get logged with
that name, if you use %a. You can also see that name in
pg_stat_activity.

ChrisA


pgsql-general by date:

Previous
From: Tianyin Xu
Date:
Subject: Re: How to print application_name in log_line_prefix (using %a)?
Next
From: Tianyin Xu
Date:
Subject: Re: How to print application_name in log_line_prefix (using %a)?