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

On Mon, Oct 29, 2012 at 4:18 PM, Tianyin Xu <tixu@cs.ucsd.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@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