pgsql: Allow notifications to bgworkers without database connections. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Allow notifications to bgworkers without database connections.
Date
Msg-id E1ZWsET-0005Gv-Q8@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Allow notifications to bgworkers without database connections.

Previously, if one background worker registered another background
worker and set bgw_notify_pid while for the second background worker,
it would not receive notifications from the postmaster unless, at the
time the "parent" was registered, BGWORKER_BACKEND_DATABASE_CONNECTION
was set.

To fix, instead instead of including only those background workers that
requested database connections in the postmater's BackendList, include
them all.  There doesn't seem to be any reason not do this, and indeed
it removes a significant amount of duplicated code.  The other option
is to make PostmasterMarkPIDForWorkerNotify look at BackgroundWorkerList
in addition to BackendList, but that adds more code duplication instead
of getting rid of it.

Patch by me.  Review and testing by Ashutosh Bapat.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/b8a439b650c4791575720dec847be61467a710a4

Modified Files
--------------
src/backend/postmaster/postmaster.c |  136 +++++++----------------------------
1 file changed, 25 insertions(+), 111 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Allow notifications to bgworkers without database connections.
Next
From: Bruce Momjian
Date:
Subject: pgsql: pg_upgrade docs: clarify rsync and move verification step