Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1itjr4-0001jq-0z for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jan 2020 03:05:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1itjr2-0003gA-Rw for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jan 2020 03:05:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1itjr2-0003g3-Ew for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2020 03:05:24 +0000 Received: from post.visena.com ([46.226.10.50]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.92) (envelope-from ) id 1itjqy-0006a0-3k for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2020 03:05:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=visena.com; s=20141101.wh; h=Content-Type:MIME-Version:Subject:In-Reply-To:Message-ID:To:From:Date; bh=ER7B4DJqaWeO4/B5290uclJ5l8xLiIX+IXz5SeSMhV0=; b=i0Sjfd9uU47q0hvjoCUARC3qEaay14PT/BmoUZivUJs6qz6lZMXNYkQfWbaS67pC90vr/eGeUHu6paErDR6HLJ1/dILLsUIj8bUypzUOZ+boEytoe3gzzGEo9rzQqecbjMM+/mog6DWgoW3Rjc8T8jrZvbxku3gn19c0Wo22B4c=; Received: from [10.0.1.10] (helo=tc7-visena.wh.internal.visena.com) by post.visena.com with esmtp (Exim 4.82) (envelope-from ) id 1itjqv-0001GL-E1 for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2020 04:05:19 +0100 Received: from localhost ([127.0.0.1] helo=tc7-visena.wh.internal.visena.com) by tc7-visena.wh.internal.visena.com with esmtp (Exim 4.90_1) (envelope-from ) id 1itjqv-0000bi-Bh for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2020 04:05:17 +0100 Date: Tue, 21 Jan 2020 04:05:17 +0100 (CET) From: Andreas Joseph Krogh To: pgsql-hackers@lists.postgresql.org Message-ID: In-Reply-To: Subject: Re: Minimal logical decoding on standbys MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_5_1235633663.1579575917270" X-Mailer: Visena Mail 2.2.220 X-Spam-Score: -1.0 X-Spam-Report: SpamAssasin (score=-1.0, required 5.0 ALL_TRUSTED=-1,HTML_MESSAGE=0.001) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_5_1235633663.1579575917270 Content-Type: multipart/related; boundary="----=_Part_6_1205465931.1579575917270" ------=_Part_6_1205465931.1579575917270 Content-Type: multipart/alternative; boundary="----=_Part_7_308845177.1579575917281" ------=_Part_7_308845177.1579575917281 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable P=C3=A5 tirsdag 21. januar 2020 kl. 03:57:42, skrev Amit Khandekar < amitdkhan.pg@gmail.com >:=20 [...] Sorry for the late reply. This patch only supports logical decoding from standby. So it's just an infrastructure for supporting logical replication from standby. We don't support creating a publication from standby, but the publication on master is replicated on standby, so we might be able to create subscription nodes that connect to existing publications on standby, but basically we haven't tested whether the publication/subscription model works with a publication on a physical standby. This patch is focussed on providing a way to continue logical replication *after* the standby is promoted as master.=20 Thanks for clarifying.=20 -- Andreas Joseph Krogh ------=_Part_7_308845177.1579575917281 Content-Type: text/html;charset=UTF-8 Content-Transfer-Encoding: quoted-printable
P=C3=A5 tirsdag 21. januar 2020 kl. 03:57:42, skrev Amit Khandekar <= ;amitdkhan.pg@gmail.com>:<= /div>
[..= .]
Sorry for the late reply.
This patch only supports logical decoding from standby. So it's just
an infrastructure for supporting logical replication from standby. We
don't support creating a publication from standby, but the publication
on master is replicated on standby, so we might be able to create
subscription nodes that connect to existing publications on standby,
but basically we haven't tested whether the publication/subscription
model works with a publication on a physical standby. This patch is
focussed on providing a way to continue logical replication *after*
the standby is promoted as master.
=C2=A0
=C2=A0
Thanks for clarifying.
=C2=A0
">
--
Andreas Joseph Krogh
------=_Part_7_308845177.1579575917281-- ------=_Part_6_1205465931.1579575917270-- ------=_Part_5_1235633663.1579575917270--