Hi ISHAN
On Fri, May 31, 2024 at 2:28 PM ISHAN CHHANGANI . < f20200...@hyderabad.bits-pilani.ac.in> wrote: > Hi, > > Is it possible to switch on/off a background worker in runtime? > As per my understanding there is no such way to do it on runtime. But you can kill it by using the following command select pg_terminate_backend(pid of bgworker); Regards Kashif Zeeshan Bitnine Global > > 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? > > Thanks, > > Ishan. > > The information contained in this electronic communication is intended > solely for the individual(s) or entity to which it is addressed. It may > contain proprietary, confidential and/or legally privileged information. > Any review, retransmission, dissemination, printing, copying or other use > of, or taking any action in reliance on the contents of this information by > person(s) or entities other than the intended recipient is strictly > prohibited and may be unlawful. If you have received this communication in > error, please notify us by responding to this email or telephone and > immediately and permanently delete all copies of this message and any > attachments from your system(s). The contents of this message do not > necessarily represent the views or policies of BITS Pilani. >
