Re: Switch background worker on/off in runtime.

On 31.05.24 11:28, ISHAN CHHANGANI . wrote:
> Is it possible to switch on/off a background worker in runtime?
> 
> worker.bgw_flags =BGWORKER_SHMEM_ACCESS;
> 
> worker.bgw_start_time =BgWorkerStart_PostmasterStart;
> 
> I want to switch off the worker based on some flag value, etc, either 
> from the main process or the worker itself.
> 
> Are there any already existing examples?

I think this depends more on your exact use case.  For example, the 
logical replication background workers have sophisticated logic to do 
this.  There is a launcher, which is itself a background worker, which 
launches other per-subscription workers.  And there are commands to 
disable subscriptions, which would among other things stop their 
corresponding background workers.  That logic is specific to the needs 
of the logic replication system.  You might get some ideas from that. 
But in general it will need a bit of custom logic.