Add functions to wait for backend termination
authorMagnus Hagander <magnus@hagander.net>
Thu, 8 Apr 2021 09:32:14 +0000 (11:32 +0200)
committerMagnus Hagander <magnus@hagander.net>
Thu, 8 Apr 2021 09:40:54 +0000 (11:40 +0200)
commitaaf043257205ec523f1ba09a3856464d17cf2281
tree61ed249bb2622454f53511d051dc1508980ab8e3
parentfb310f17812e7321599845a29af2f36c7f1191c3
Add functions to wait for backend termination

This adds a function, pg_wait_for_backend_termination(), and a new
timeout argument to pg_terminate_backend(), which will wait for the
backend to actually terminate (with or without signaling it to do so
depending on which function is called). The default behaviour of
pg_terminate_backend() remains being timeout=0 which does not waiting.
For pg_wait_for_backend_termination() the default wait is 5 seconds.

Author: Bharath Rupireddy
Reviewed-By: Fujii Masao, David Johnston, Muhammad Usama,
             Hou Zhijie, Magnus Hagander
Discussion: https://postgr.es/m/CALj2ACUBpunmyhYZw-kXCYs5NM+h6oG_7Df_Tn4mLmmUQifkqA@mail.gmail.com
doc/src/sgml/func.sgml
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/storage/ipc/signalfuncs.c
src/backend/utils/activity/wait_event.c
src/include/catalog/pg_proc.dat
src/include/utils/wait_event.h