Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDdpU-0006Dm-Mq for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Jan 2022 02:51:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nDdpS-0001PI-Vk for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Jan 2022 02:51:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDdpS-0001P9-Kt for pgsql-hackers@lists.postgresql.org; Sat, 29 Jan 2022 02:51:06 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nDdpL-0004AU-VL for pgsql-hackers@lists.postgresql.org; Sat, 29 Jan 2022 02:51:05 +0000 Received: by mail-pl1-x635.google.com with SMTP id x11so7848284plg.6 for ; Fri, 28 Jan 2022 18:50:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=HnWu7Jeh2Sq74A6tzYIO/HDDwCote0O3hb7L6z+w2uw=; b=Mq0uyxzO5kt8im3tCaSW6W/wPe907PmQT71IV5IUtVPinfkQPvB3/Zsn1UXNtw4DP0 34A4X5s3jtlN8W4j9jnbKXs0ER+jej4UNEyr5fXL5MBbp432fOyr1V1OLFW7iB/aPqMq XoQjvU9yYiBfQqSZ7LEio2v/WMLJnh1EN8RcmeTcn6x7M+k7odqdedcMxuy2TjIr9Y1c 6A+xD/fQTVdpi7kxVkeQeOOLEA7DBJZTnhAdZAKsrhU8ZtN8DX38GnFu2Jp//u0bLx8B Iif/09FnDEXBLlD7X+IITtiss2qgrlv3ShryYo7l8UeZVVHkJ6bhGCnpGwwGwL8VG8Ze ue6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=HnWu7Jeh2Sq74A6tzYIO/HDDwCote0O3hb7L6z+w2uw=; b=vHAZYpES8AcqUFHSjlHmazWzUA+vZ4LDSm6yQn+ygbB8zsZaZJ3Ucf0V1XUAjzkf8H Rb5QQG0N3rWcHPXTCcXyn11fmZcUoz8IJ/VyHsrLbNVbS3/3FLG7WiiZ9a/nJ2E5rGaZ b08lPE/rhjzGSQC8CNcA1hh8jJAHWyZgQeuHXPMNwCuChpXH7pOtWFqILrJQaVod4XZP dSfW+og+KExe1/+mTCmyhJWN1NQPbn29Giy51l3bLi7IxGMT7ZM5gDFRud+Tt0gahC9v Y4/oSvbjnb/mBw+q/tI7lkMvg2YTT+siGlklj7Mbz4Khw3VLNYUdmNeWdfrb0f7FTOu7 5lHQ== X-Gm-Message-State: AOAM531vpcCBpu+9TAi0LmhANO2Z1OUbdzIaGO2eyo6LkHaVbfQKeGTi j1N8pRSrjtNBXuqHsN46keM= X-Google-Smtp-Source: ABdhPJylmfh0ofVGoTOKx2a9/1oPTN9RQ3e51DeoB+SuqVZTgoS+5l8M3g3CkTGJVMS+6/Gp9WYAlQ== X-Received: by 2002:a17:902:7c02:: with SMTP id x2mr10911486pll.47.1643424658700; Fri, 28 Jan 2022 18:50:58 -0800 (PST) Received: from jrouhaud (2001-b011-1005-557a-942d-0024-7821-6548.dynamic-ip6.hinet.net. [2001:b011:1005:557a:942d:24:7821:6548]) by smtp.gmail.com with ESMTPSA id f13sm10230851pfc.80.2022.01.28.18.50.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 28 Jan 2022 18:50:58 -0800 (PST) Date: Sat, 29 Jan 2022 10:50:50 +0800 From: Julien Rouhaud To: Andres Freund Cc: Denis Laxalde , pgsql-hackers@lists.postgresql.org, Jehan-Guillaume de Rorthais Subject: Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Message-ID: <20220129025050.eqldwt3v2gothq5i@jrouhaud> References: <20210121152357.s6eflhqyh4g5e6dv@dalibo.com> <20210124003611.lkyxhd2mpdmv5xzh@alap3.anarazel.de> <20210127102511.tvhu2wmrxoz3tle4@dalibo.com> <20210127144132.215fe4bb@firost> <20210312082325.weltivlokfpc3gt2@nol> <54f0d813-a38a-6b72-269a-7d6dd02bcc5b@dalibo.com> <20220128135636.ls2zjbajirbdmrzb@jrouhaud> <20220128182007.jt5defrrfdb4kr7i@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220128182007.jt5defrrfdb4kr7i@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Jan 28, 2022 at 10:20:07AM -0800, Andres Freund wrote: > > On 2022-01-28 21:56:36 +0800, Julien Rouhaud wrote: > > I think having a new option for vacuumdb is the right move. > > Can't we pass the option via the connection string, e.g. something > PGOPTIONS='-c binary_upgrade_mode=true'? That seems to scale better than to > add it gradually to multiple tools. Ah right that's a better idea.