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

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?

T

On Sun, Oct 28, 2012 at 10:27 PM, Chris Angelico <rosuav(at)gmail(dot)com> wrote:

> On Mon, Oct 29, 2012 at 4:18 PM, Tianyin Xu <tixu(at)cs(dot)ucsd(dot)edu> wrote:
> > However, I have the following configuration settings in postgresql.conf
> >
> > application_name = 'mypostgres'
> > log_line_prefix = '[%a] '
> >
>
> I'm not familiar with this usage of setting application_name in
> postgresql.conf - usually I set it as part of the database connection.
> For example:
>
> //In Pike:
> object db=Sql.Sql("pgsql://USER:PASSWORD(at)HOST
> /DATABASE",(["search_path":"SCHEMA,public","application_name":"APPLICATION"]));
>
> //In PHP:
> $db=pg_connect('dbname=DATABASE host=HOST user=USER password=PASSWORD');
> pg_query($db,"set application_name='APPLICATION'");
> pg_query($db,"set search_path to SCHEMA,public");
>
> 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/