From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: setting application name post connection |
Date: | 2010-10-08 04:16:56 |
Message-ID: | AANLkTi=1+Uro6+D06-tT=ccuT7gfS6ieMLah8r+HE6TQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yep it works!
thanks.
t=> show application_name;
application_name
------------------
(1 row)
t=> SELECT application_name,current_query from pg_stat_activity
where application_name='myapp';
application_name | current_query
------------------+---------------
(0 rows)
t=> set application_name TO 'myapp';
SET
t=> SELECT application_name,current_query from pg_stat_activity
where application_name='myapp';
application_name | current_query
------------------+-----------------------------------------------------------------------------------------------
myapp | SELECT application_name,current_query from
pg_stat_activity where application_name='myapp';
(1 row)
t=>
On Thu, Oct 7, 2010 at 11:49 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
> <mallah(dot)rajesh(at)gmail(dot)com> wrote:
>> Dear List,
>>
>> Is it possible to set application name param after the connection is made?
>
> Have you tried setting it:
>
> set application_name = 'newappname';
>
> ?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Timon | 2010-10-08 04:43:57 | Fwd: stuck spinlock detected at dynahash.c |
Previous Message | Scott Marlowe | 2010-10-08 03:49:54 | Re: setting application name post connection |