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
signature.asc
Description: PGP signature