On 28 June 2016 at 08:28, Akash Agrawal <aagra...@ncsu.edu> wrote:
> I've handled SIGTERM signal. pg_terminate_backend send signals (SIGTERM)
> to backend processes identified by process ID. And also, after this call I
> am able to track in my logs that the background worker gets terminated.
> Yet, I am only able to register first 8 background workers. I am using
> select worker_spi1_launch(1) to launch it every time. This is why I guess
> there is some metadata maintained which has got to be deleted.
(Please reply below other posts, not above)
The bgworker API currently offers no way to enumerate bgworkers or
unregister them from the outside. The only way to unregister a dynamic
bgworker is to:
* proc_exit(0) from within the worker; or
* register it with BGW_NO_RESTART so it doesn't auto-restart in the
This is a deficiency in the bgworker API, but there are workarounds in
place and other things are more important for now. Just make your your
workers proc_exit(0) on SIGTERM or don't register them as auto-restarting.
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services