From: | Tianyin Xu <tixu(at)cs(dot)ucsd(dot)edu> |
---|---|
To: | Chris Angelico <rosuav(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to print application_name in log_line_prefix (using %a)? |
Date: | 2012-10-29 06:44:24 |
Message-ID: | CABBDWwdMZdY1i8MfYmOUr78fFp31RSBVBLXZD_cd-xb5ZyWCOA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Got it! Thanks, Chris!
I still wonder why application_name appears in the configuration file if it
cannot take effort :-P
T
On Sun, Oct 28, 2012 at 11:29 PM, Chris Angelico <rosuav(at)gmail(dot)com> wrote:
> On Mon, Oct 29, 2012 at 5:22 PM, Tianyin Xu <tixu(at)cs(dot)ucsd(dot)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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
From | Date | Subject | |
---|---|---|---|
Next Message | 高健 | 2012-10-29 07:17:10 | Why BgWriterDelay is fixed? |
Previous Message | Chris Angelico | 2012-10-29 06:29:24 | Re: How to print application_name in log_line_prefix (using %a)? |