Thread: setting application name post connection

Dear List,

Is it possible to set application name param after the connection is made?

In our applications the DB connection is made at a top level and is
shared between
many sub-applications. We want to override the application name in
various sub-applicatons
without reconnecting to the database. Is it possible?

regds
Rajesh Kumar Mallah.

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';

?

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';
>
> ?
>