On Mon, Oct 29, 2012 at 5:22 PM, Tianyin Xu <tixu@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general