Re: [PATCH] Disable bgworkers during servers start in pg_upgrade - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] Disable bgworkers during servers start in pg_upgrade
Date
Msg-id YSmUGhShJBBIcyZb@paquier.xyz
Whole thread Raw
In response to Re: [PATCH] Disable bgworkers during servers start in pg_upgrade  (Andres Freund <andres@anarazel.de>)
Responses Re: [PATCH] Disable bgworkers during servers start in pg_upgrade
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade
List pgsql-hackers
On Fri, Aug 27, 2021 at 12:28:42PM -0700, Andres Freund wrote:
> Isn't that just going to end up with extension code erroring out and/or
> blocking waiting for a bgworker to start?

Well, that's the point to block things during an upgrade.  Do you have
a list of requirements you'd like to see satisfied here?  POWA would
be fine with blocking the execution of bgworkers AFAIK (Julien feel
free to correct me here if necessary).  It could be possible that
preventing extension code to execute this way could prevent hazards as
well.  The idea from upthread to prevent any writes and/or WAL
activity is not really different as extensions may still generate an
error because of pg_upgrade's safety measures we'd put in, no?
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Denis Smirnov
Date:
Subject: Re: Async-unsafe functions in signal handlers
Next
From: Julien Rouhaud
Date:
Subject: Re: [PATCH] Disable bgworkers during servers start in pg_upgrade