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 1mhg2k-0003kH-4f for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Nov 2021 22:44:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mhg2j-0000v6-2J for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Nov 2021 22:44:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mhg2i-0000ux-QK for pgsql-hackers@lists.postgresql.org; Mon, 01 Nov 2021 22:44:40 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mhg2f-0007YF-2O for pgsql-hackers@postgresql.org; Mon, 01 Nov 2021 22:44:40 +0000 Received: by mail-pf1-x42c.google.com with SMTP id o14so4304273pfu.10 for ; Mon, 01 Nov 2021 15:44:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=qiw+/m7WCcrdPR75eXmvpW8Amg4nCC0e0V2DHj8cZlE=; b=T6dEQ1rToX/qwMaFb5wzfZmj6KbO9aXHc/Giga7LR2MpBievc8xCw9U+htbLM1KBVJ 4+90wow89lppOj+dDPQyxL0M0/U0poaF+Xc5TgjtkHN41hMA5CtEx0Mtof3bO6XGMiUN kphIc8z2TC7aFKHFM2T5tkGxHT3RWDGWR7iXVo6jt8Rq31g/Lk1PEiDhCkw48KKspAEh vl3Uu2rmpys0tKkJRLHaXs+17M8EHO4zJnGt8o2MdACgjmFZVM46nVrTRmYkQ2W89ea6 o8+bplc4cU6HVH/IRJLLpkkptkZIkg+raVrjWKb++ceV5SZ1OPD1RBtJDQoV9VDLzar9 zmrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=qiw+/m7WCcrdPR75eXmvpW8Amg4nCC0e0V2DHj8cZlE=; b=HmBZs9wIGXiFA8QSmDc8l1dSi3E3mCAwk4Djyz5nCeiGSUX6VD3CNBBIFxZoP9rWRD G0mv9T6Z/PlKDEvZDCZk/og7CuroanVckbZqzBgE1BcgMqL+sKSRQW4XGZ5wVNaC/Ovs MABx5JU/KyHzTa1yOD5avYzW5G8o/gOifBdF9xYgtR8YrAcwy1igZvO6wCNTHl+SKCBi mq9IspCTNJmaDiN36/f+ulXPOEU103l3Q5Bue8pg5bRWfiXeMh6PsCmTJEDawed2p0rJ KrmO+vQcn8YHvS/naJ0r7UiITU/OkDY9EiydOom4PxREcrCkcbDKvqIjK3uEa0+blHcN gTfA== X-Gm-Message-State: AOAM531g6QJmq5hAoZjphuLqxSiQsZsuFGvDGvA+TdWxxA9sVS8gN/NZ Fj4mh9zHy1/TXQD6r5U1cZcU88hMKnHm2DLmCKm0wWFZ6Cku8Du6DsWXHKyW2HsGRTJtvaaH1/0 C2C4D2Cgd0RVcys8wskysNgG6QRPgQtM0PYcyk681QbcY2aOwrmkEWaU9pMN/lxOIod5hg0ghO4 5FAB4bWCH8/LXgHYWCYE921zL4qcypxl6SXGscikuYS/MDOfhGDJ3KLPbto6hFV2XTs2R8pauNP 7HK7q33hc2+ux7rMXbpoos6d6jK/ICN92xg X-Google-Smtp-Source: ABdhPJyWrNRh0kM9ObXHAPFMPgZCfRLKwxVgEYPOP2AfiEd3W5jRlUvEN6lMXK+14sokWSUUKxYBJw== X-Received: by 2002:a63:7006:: with SMTP id l6mr24060077pgc.402.1635806674247; Mon, 01 Nov 2021 15:44:34 -0700 (PDT) Received: from laptop280-ma-us.hitronhub.home (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id k1sm397202pjj.54.2021.11.01.15.44.33 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 01 Nov 2021 15:44:33 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: Non-superuser subscription owners From: Mark Dilger In-Reply-To: Date: Mon, 1 Nov 2021 15:44:32 -0700 Cc: Andrew Dunstan Content-Transfer-Encoding: quoted-printable Message-Id: <6ADE0BED-0B46-4BF0-AEDC-0D2D08648945@enterprisedb.com> References: <9DFC88D3-1300-4DE8-ACBC-4CEF84399A53@enterprisedb.com> To: PostgreSQL-development X-Mailer: Apple Mail (2.3608.120.23.2.7) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Nov 1, 2021, at 10:58 AM, Mark Dilger = wrote: >=20 > ALTER SUBSCRIPTION..[ENABLE | DISABLE] do not synchronously start or = stop subscription workers. The ALTER command updates the catalog's = subenabled field, but workers only lazily respond to that. Disabling = and enabling the subscription as part of the OWNER TO would not reliably = accomplish anything. Having discussed this with Andrew off-list, we've concluded that = updating the documentation for logical replication to make this point = more clear is probably sufficient, but I wonder if anyone thinks = otherwise? =E2=80=94 Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company