set parameter for all existing session

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

set parameter for all existing session

alex lock
I check the “alter database, alter role " and "set " command, but none of them can set the parameters to all the existing sessions.   do we have a way to do that?  looks the "assign_hook" can be used to customize this,  is it a right way to do that?


Reply | Threaded
Open this post in threaded view
|

Re: set parameter for all existing session

Pavel Stehule
Hi

st 12. 6. 2019 v 9:58 odesílatel alex lock <[hidden email]> napsal:
I check the “alter database, alter role " and "set " command, but none of them can set the parameters to all the existing sessions.   do we have a way to do that?  looks the "assign_hook" can be used to customize this,  is it a right way to do that?


Maybe you miss to call pg_reload_conf();

example:

alter system set work_mem to '10MB';
select pg_reload_conf();

in other session you can:

show work_mem;

Regards

Pavel
Reply | Threaded
Open this post in threaded view
|

Re: set parameter for all existing session

alex lock


On Wed, Jun 12, 2019 at 4:25 PM Pavel Stehule <[hidden email]> wrote:
Hi

st 12. 6. 2019 v 9:58 odesílatel alex lock <[hidden email]> napsal:
I check the “alter database, alter role " and "set " command, but none of them can set the parameters to all the existing sessions.   do we have a way to do that?  looks the "assign_hook" can be used to customize this,  is it a right way to do that?


Maybe you miss to call pg_reload_conf();

example:

alter system set work_mem to '10MB';
select pg_reload_conf();

Thanks,  it works! 

in other session you can:

show work_mem;

Regards

Pavel