Re: setting application name post connection - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Re: setting application name post connection
Date
Msg-id AANLkTi=1+Uro6+D06-tT=ccuT7gfS6ieMLah8r+HE6TQ@mail.gmail.com
Whole thread Raw
In response to Re: setting application name post connection  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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.marlowe@gmail.com> wrote:
> On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
> <mallah.rajesh@gmail.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';
>
> ?
>

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: setting application name post connection
Next
From: Timon
Date:
Subject: Fwd: stuck spinlock detected at dynahash.c