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 <[email protected]> wrote: > On Mon, Oct 29, 2012 at 5:22 PM, Tianyin Xu <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
