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.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tNZI0-000fcS-A6
	for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 15:15:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tNZHy-002k1U-Oa
	for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 15:15:10 +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.94.2)
	(envelope-from <sbob@quadratum-braccas.com>)
	id 1tNZHx-002k0X-JF
	for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2024 15:15:10 +0000
Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <sbob@quadratum-braccas.com>)
	id 1tNZHu-00032r-Hy
	for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2024 15:15:08 +0000
Received: from phl-compute-06.internal (phl-compute-06.phl.internal
 [10.202.2.46])
	by mailfout.phl.internal (Postfix) with ESMTP id CB0ED13801A7;
	Tue, 17 Dec 2024 10:15:04 -0500 (EST)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-06.internal (MEProxy); Tue, 17 Dec 2024 10:15:04 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	quadratum-braccas.com; h=cc:content-transfer-encoding
	:content-type:content-type:date:date:from:from:in-reply-to
	:message-id:mime-version:reply-to:subject:subject:to:to; s=fm3;
	 t=1734448504; x=1734534904; bh=T9qi3j1Vkh8kwx9OyfJ3mgEaFpwuV754
	AcyMaRn58wk=; b=RNahYUHCYuM3tQu+VXWchfKkrDHGn5aebWq8SPYSd7MANMVd
	+1fW8QsCP49vDxRw/KenMjy9Y27LjXNxKXBtEBEvZdtiCAnd25Q5lhhjJhCnp7eu
	DUpX9780ija2BB61B+vsbC3ND9bY4LfD74dajAf9P/EwmqZuI2qAmpfzxHXVCGw0
	yOQ2HjeOqKm39jAa4uq6OU1x6C/rare0SxseRgtsAycRai3Vaq24eIptwZBJNR3+
	cV1zeW+2ZbD0myXFSNyO65T7GNH/KeZuUDdhxpF2Tj8ETIBdMPnC1j3UTODwcdwq
	my263u1SIdAPMfHp2Kq9x/i71kV7WQwAB5nmMg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:message-id:mime-version:reply-to:subject:subject:to
	:to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=
	1734448504; x=1734534904; bh=T9qi3j1Vkh8kwx9OyfJ3mgEaFpwuV754Acy
	MaRn58wk=; b=aKO73zR1tWizz0TtYY9JHbYsyrmAOk2bOzzvTswPzoIwkXs5Pbc
	cjXmjqIuxSgCrs9JjJGBlKgA/7nGRBV/SfSp1bsB2yP3q0uCoAe0J3dLxlDGWzTi
	ymoaf2mqelVO/9gtYPDiBgLR7StxzwZEq5XJBvWVv/1/wbIt7gtYrDpVpipBY4jt
	F1iXaFpcl9ogCJtEFMB9nSGaeTq8TfqJlGPlxCB78j2Fa1RmxPdY/Q8XYxu6O1MP
	54xgCuSjZ4UXmb+IKe418X0tV7gYXkUaiJo/56vYd0pKerKgD4xh5PZdaTL9FKVL
	uHNdgwqyJo92ray4uyWVwboJFOGIUx+6g1A==
X-ME-Sender: <xms:eJVhZ5pKIU2OzYFctHIOpezmeti7jaza8d8O6PrzVFzRK9zzKEy1-w>
    <xme:eJVhZ7o7IVrizmcenOb-p2_MaTkh6V-i1_wMMCfv_E514_z4liF6NSqzyBQ3K4uBQ
    ly3e2ZaEWWClL310s4>
X-ME-Received: 
 <xmr:eJVhZ2Pip45JTfywdCmaq4JxnAqIV7WHLCnWdrsRxsNsEee_g7d6HGWpTHZyqQ>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeefuddrleehgdejhecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr
    tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfvf
    fhufgtgfesthejredttddvjeenucfhrhhomhepufgsohgsuceoshgsohgssehquhgrughr
    rghtuhhmqdgsrhgrtggtrghsrdgtohhmqeenucggtffrrghtthgvrhhnpefgiedtfeegve
    etffelkedutedufeffhffgleehtedutedtleffvdfgjeekveeikeenucevlhhushhtvghr
    ufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgrth
    humhdqsghrrggttggrshdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhht
    phhouhhtpdhrtghpthhtohepphhgshhqlhdqrggumhhinheslhhishhtshdrphhoshhtgh
    hrvghsqhhlrdhorhhgpdhrtghpthhtohepshgsohgssehquhgrughrrghtuhhmqdgsrhgr
    tggtrghsrdgtohhm
X-ME-Proxy: <xmx:eJVhZ07CB2XU7Ac_nYgZHq7IVddyd7myc2TibfVOUJoaowjHKp_PQQ>
    <xmx:eJVhZ46TC_08-ZiI56jnGB5EJAiRoglUfK87kk_l_eF1VZqgjEATYw>
    <xmx:eJVhZ8gDTtBycxCOlkph2k5znB54J-l6uECFwIIaWLWbxbq6atAbvQ>
    <xmx:eJVhZ67dmicJaDGAqoQggYHo7cqMhta_Wt6aWpaccCcx74SJtaxErg>
    <xmx:eJVhZ4FEdBG_KTRd1-SCaMY_-PsxR5gribQNvhPnGJBQBvoQmva9dQwE>
Feedback-ID: i374947ac:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue,
 17 Dec 2024 10:15:03 -0500 (EST)
Message-ID: <76c0af90-a4ca-4d7b-9beb-b6056e5a0fdf@quadratum-braccas.com>
Date: Tue, 17 Dec 2024 08:15:02 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-admin@lists.postgresql.org
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: Streaming replication with a master that has a logical replication
 subscription
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/76c0af90-a4ca-4d7b-9beb-b6056e5a0fdf%40quadratum-braccas.com>
Precedence: bulk

All

We are setting up a hot standby from a master that has a logical 
subscription configured, but we dont want the logical subscription on 
the hot standby.

Is there a way to tell pg_basebackup to skip logical subscriptions? Or 
can I drop the subscription while the standby is not yet promoted?


Thanks in advance