From b265b6f5b49cfcbc3c6271e980455696a5a3622b Mon Sep 17 00:00:00 2001 From: Denis Laxalde Date: Mon, 23 Aug 2021 15:19:41 +0200 Subject: [PATCH] Do not start bgworker processes during binary upgrade Background workers may produce undesired activities (writes) on the old cluster during upgrade which may corrupt the new cluster. For a similar reason that we restrict socket access and set default transactions to read-only when starting the old cluster in pg_upgrade, we should prevent bgworkers from starting when using the -b flag. --- src/backend/postmaster/postmaster.c | 3 +++ 1 file changed, 3 insertions(+) diff --git a/src/backend/postmaster/postmaster.c b/src/backend/postmaster/postmaster.c index 9c2c98614a..e66c962509 100644 --- a/src/backend/postmaster/postmaster.c +++ b/src/backend/postmaster/postmaster.c @@ -5862,6 +5862,9 @@ do_start_bgworker(RegisteredBgWorker *rw) static bool bgworker_should_start_now(BgWorkerStartTime start_time) { + if (IsBinaryUpgrade) + return false; + switch (pmState) { case PM_NO_CHILDREN: -- 2.30.2