Re: How to print application_name in log_line_prefix (using %a)?

Поиск
Список
Период
Сортировка
От Tianyin Xu
Тема Re: How to print application_name in log_line_prefix (using %a)?
Дата
Msg-id CABBDWwdMZdY1i8MfYmOUr78fFp31RSBVBLXZD_cd-xb5ZyWCOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to print application_name in log_line_prefix (using %a)?  (Chris Angelico <rosuav@gmail.com>)
Ответы Re: How to print application_name in log_line_prefix (using %a)?  (Chris Angelico <rosuav@gmail.com>)
Список 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@gmail.com> wrote:
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Angelico
Дата:
Сообщение: Re: How to print application_name in log_line_prefix (using %a)?
Следующее
От: 高健
Дата:
Сообщение: Why BgWriterDelay is fixed?