Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgW2F-00EcLt-1i for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 15 Jan 2026 22:41:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgW2E-001j6q-2A for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 15 Jan 2026 22:41:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgW2E-001j6e-1P for pgsql-pkg-debian@lists.postgresql.org; Thu, 15 Jan 2026 22:41:46 +0000 Received: from mail-wr1-x429.google.com ([2a00:1450:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vgW2B-000e7j-3B for pgsql-pkg-debian@lists.postgresql.org; Thu, 15 Jan 2026 22:41:45 +0000 Received: by mail-wr1-x429.google.com with SMTP id ffacd0b85a97d-430fbb6012bso1078015f8f.1 for ; Thu, 15 Jan 2026 14:41:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1768516902; x=1769121702; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=wH/EPufKx+6oI+fmhfDk/nVeNOeeXrpn1+rwHYxgEG8=; b=RqfGrOlvazrd1TZ681cuzedmWHJcNgr0tHQsS1Jy/zUIanVtCn8rxYxTDWpIxOOQy5 VSepecQTghQa6WinnIr4yIlMLtPw537ECxVgg+Q19SBiULqegtS3hs9pWmG1vGQCZQ0D C+mM59NDcwQV43uBqMw8yMbAmo7j+JyZ1jm1IegYHprZmqlGb0es1rdFY4S97Zl8alzL K4eNKvUg7LfXTTXTWaTEmDp0t4B+hBKaON2HZDmvuobleAiLFtTboXTTRsIYD5/yazbs +gkkNct6PwKgkmuG+wileYm694U6Nwa8Ihp5uKaMzDEr5yzzn3GqXt3CX4XYb6SANQEm OSQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768516902; x=1769121702; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=wH/EPufKx+6oI+fmhfDk/nVeNOeeXrpn1+rwHYxgEG8=; b=OgX0/1dXCQvYjYVD4CSRl1syHzzwaEcQBfkj/9JgFtjE3jm7GFksz9vbbgSVBOxOoM sGA6XwJFCaQoNObmkbC7ypba8rqD5VAYEXu1aohAAG2ic9TzP6UhSAURKRxQi3uOITrt bfgmcQ2zXDuIt84AIIZG8LxfLVNQ+QZ9ugFDFzpbZX3obTZNBVIcuvlLjoiId95KxoV8 ARA8RNxcRpaex775xMMoHUkEvTgbZSWTUb90xd6IL+/KFFVSyXCEdrGER9xPxN8mCv6q oQ7QnYe4S9iEgmTZLlVAg7pPWdyycznJcoiy4oNjVy8GZFOvlfzHqKsq2YWDsrZw/qez EQxA== X-Gm-Message-State: AOJu0YxBxuHDDOeaKDulbMvhl5KEeZC+1xVKuEWPYYrN7GjWicRGo12b p08kVKHCD3GBIdaReHC2qCdo1Hc2RhblqBIdG7eqcRACf8vtTQW0ZEoJrvA22ysArKY= X-Gm-Gg: AY/fxX43QWcm1nhVv0HoUocohhYpLoyOpY84LjyhBwFW964cLJNJiafZ7w1PmZFcE6c hy/SrDFtHw5Hpu6BL3BeryhWVVTClbfU1U8LnSaDOW01jKH0FpQ1JhOOFGw1lFF2r66P5dJnv4n LcyEperwOhhjGsUs+ceu9oXuz3tFCc3RQfF6IBMQ8zplsl79GxvG61PlhVrwKjTDRonrBatsNQi Lr6L6wjqAEftw1h295kCnjFjXHBAUVDrG5XxJGiCZ2zu0kFsXMFnjsE2GpdphUhtlQti09VY/ou b3Epn2f8jFOOlWpaC5LL+XDdLyRCXxI1FskcPTsrzLarmS0m48yBzruZ//ZD3b+gvHSxkkOMF4f 6GDsP2qx9Y1PrOdNrk8Z2PaAT6jkX9l0Zaw48EHDQCA4O6+kNVdMrgI1dZNhE8dPktnbohq/bq6 QzaUARBrHhiHHvX+lVnZTqF2HAp9YfEqUqpyZ/kKBo6nc= X-Received: by 2002:a05:6000:186b:b0:430:fa58:a03d with SMTP id ffacd0b85a97d-43569bd09c5mr1090573f8f.63.1768516901764; Thu, 15 Jan 2026 14:41:41 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:4cd4:ad4e:e4e4:66cb:81ac]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-435699271easm1427297f8f.14.2026.01.15.14.41.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Jan 2026 14:41:41 -0800 (PST) Message-ID: Subject: Re: pg_upgradecluster and synchronous replication From: Laurenz Albe To: Christoph Berg Cc: pgsql-pkg-debian@lists.postgresql.org Date: Thu, 15 Jan 2026 23:41:40 +0100 In-Reply-To: References: Content-Type: multipart/mixed; boundary="=-68OXieReorAuLwwSzGs9" User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-68OXieReorAuLwwSzGs9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, 2026-01-15 at 05:40 +0100, I wrote: > > On Wed, 2026-01-14 at 20:39 +0100, Christoph Berg wrote: > > >=20 > > > Maybe we should instead change the analyze hook script to do that > > > internally? Setting PGOPTIONS should be enough: > > >=20 > > > =C2=A0=C2=A0=C2=A0 PGOPTIONS=3D"-csynchronous_commit=3Dlocal" > > Yes, I think that is the proper solution! How about the attached patch? Yours, Laurenz Albe --=-68OXieReorAuLwwSzGs9 Content-Disposition: attachment; filename*0=v2-0001-Prevent-ANALYZE-from-waiting-for-synchronous-stan.pat; filename*1=ch Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="v2-0001-Prevent-ANALYZE-from-waiting-for-synchronous-stan.patch"; charset="UTF-8" RnJvbSA4ZWU3NGIzZjE3YWIzYjlhNGYxOGQ1ODU3NjliYThkYTA1Yzk2ZmM1IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogVGh1LCAxNSBKYW4gMjAyNiAyMzozNzowMCArMDEwMApTdWJqZWN0OiBbUEFUQ0gg djJdIFByZXZlbnQgQU5BTFlaRSBmcm9tIHdhaXRpbmcgZm9yIHN5bmNocm9ub3VzIHN0YW5kYnlz CgpJZiB0aGUgY2x1c3RlciB0byB1cGdyYWRlIGhhcyBzeW5jaHJvbm91cyByZXBsaWNhdGlvbiBj b25maWd1cmVkLAoidmFjdXVtZGIgLS1hbmFseXplLW9ubHkiIHdpbGwgaGFuZyB3YWl0aW5nIGZv ciB0aGUgZmVlZGJhY2sgb2YgYQpzeW5jaHJvbm91cyBzdGFuZGJ5LCBidXQgdGhlcmUgaXMgbm9u ZSBkdXJpbmcgYW4gdXBncmFkZS4KClRvIHByZXZlbnQgdGhhdCwgc2V0ICJzeW5jaHJvbm91c19j b21taXQiIHRvICJsb2NhbCIgd2hpbGUgb3B0aW1pemVyCnN0YXRpc3RpY3MgYXJlIGJlaW5nIGNh bGN1bGF0ZWQuCgpodHRwczovL3Bvc3Rnci5lcy9tL2ZsYXQvZDNmMjEwMjljOGVhMTFmNmE2MWNm YjgwNDVhYzExNDgwNzg3NDExZS5jYW1lbEBjeWJlcnRlYy5hdAotLS0KIHBnX3VwZ3JhZGVjbHVz dGVyLmQvYW5hbHl6ZSB8IDMgKysrCiAxIGZpbGUgY2hhbmdlZCwgMyBpbnNlcnRpb25zKCspCgpk aWZmIC0tZ2l0IGEvcGdfdXBncmFkZWNsdXN0ZXIuZC9hbmFseXplIGIvcGdfdXBncmFkZWNsdXN0 ZXIuZC9hbmFseXplCmluZGV4IDY0ODBiNWUuLjJhOGQxNDUgMTAwNzU1Ci0tLSBhL3BnX3VwZ3Jh ZGVjbHVzdGVyLmQvYW5hbHl6ZQorKysgYi9wZ191cGdyYWRlY2x1c3Rlci5kL2FuYWx5emUKQEAg LTE5LDYgKzE5LDkgQEAgY2FzZSAkbmV3dmVyc2lvbiBpbgogICAgICAgICA7OwogZXNhYwogCisj IGRvbid0IGhhbmcgd2FpdGluZyBmb3IgYSBzeW5jaHJvbm91cyBzdGFuZGJ5IHNlcnZlcgorZXhw b3J0IFBHT1BUSU9OUz0iJFBHT1BUSU9OUyAtY3N5bmNocm9ub3VzX2NvbW1pdD1sb2NhbCIKKwog Y2FzZSAkbmV3dmVyc2lvbiBpbgogICAgIDkuMnw5LjMpCiAgICAgICAgIHZhY3V1bWRiICRmbGFn cyAtLWFuYWx5emUtb25seQotLSAKMi41Mi4wCgo= --=-68OXieReorAuLwwSzGs9--