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 1p3B5k-0001s9-2g for pgsql-general@arkaria.postgresql.org; Thu, 08 Dec 2022 07:13:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3B5i-0002qx-Rb for pgsql-general@arkaria.postgresql.org; Thu, 08 Dec 2022 07:13:10 +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 1p3B5i-0002m7-AK for pgsql-general@lists.postgresql.org; Thu, 08 Dec 2022 07:13:10 +0000 Received: from sonic313-21.consmr.mail.sg3.yahoo.com ([106.10.240.80]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p3B5f-0002Qk-EP for pgsql-general@lists.postgresql.org; Thu, 08 Dec 2022 07:13:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670483582; bh=m9cBq71H4Zl574bt1pUPqH/lfFMYvWpFc9wcu8tdczE=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=AfyvnHDyNR3a4POIQe42eE3yCLl+I0NxC7jyoGr6wET7zWk947nSfH6wtKXAQg0Grao2uV86KGJ8Trphoz+8XRR6hkuU21eLVr3yINO7b03uP5Xe9JfQACGrRbSQPvrWOf5LGVM+xmN39J9uiJ7tbJ1/S3Wv1/VOEmqOX6ce1Q2B9O/lNx1jPjccpyq8YfI0NXd0qVIsOdv7nhhR2ALMy1wGmCsXHeubEwcYmkapb1t1slr+vBicF2dyKixMx2D1Qw533Uv/pzo/x4rwJ9IV9cqp5awolchob1EEcslHuBuhzCrOzDnFnl1vja2utwM89KdK8FPa144SLSQ/Rzodzg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670483582; bh=ntLC1rjJaFm/zYcLuWl1hyAclcxPbkS84gs5yRrnKgf=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=I6WEdGbMU0zXL89L5pc4VFiNA5t//dqMWcqldaq+Af62SIJhM+srNoks4gHnqxPVr4Qwr78H6/34CXrV4j8WjxJ5MLmx5dy3kYGD3RrhhSEy9t17OitJpJOuWfeLc+YhyTpcdbq3hvnlpnITYqdOPwArEuN39p/x7+qIf84h4PlGGj9QiWzZuwiSR/jDhXK1UY2+Bpx2NsOvIgive0rDUClW5YAedccnvf5HP/hg9fl4BEQtbLOLpCwbSKfB7uziEDog0+QvDrBeHaDKZsI5+0VQK8k65857VxztbXj4RjO7yXTlXc5P/XenDkDhGjfy+sqPQkYZjp3ESP8si0B2mg== X-YMail-OSG: NLXyyboVM1kpF8ZhkWzWQfYZeSutqzZpw4U.cmucQiP0GIoB2RyXYCFuRzF1Xl7 c4vWwRtEi_Hedw25JCtgkQUf.yXFEwF98UMPSdCjfFYMvNTMl8dnN6MeMYY.RXiqcbn5Lmw0XcwH bsB6Vn4WCEQpdNnGCy8Yf2_lO587tLvRUm1nDerqlYhK6cniFGT7YcsBJVT33ywhRd61Cghd6opk xtRtKob7VtorU_cU4Hssg5ESBOUuxWXkmy8lcbGwWj0U6UZrbrnHfNY8vDIVjjH7bgwmaTE5ghRy 7YiATD14jivIHKFZ5MTnbyGGcW2rM_8.wSRyHWmMEufpCVxXRgjSEqtqwBIaZPFDUX_y.L7wabqi CIyZQveZugehLceYUFll.WrxIMhkrC0.TzO0yjSa_MEKauF9TfLya1Xc4IF7BQ2Ihe8uFikynUbJ OJzj6_1gwlZ_ybhpyPau_4VLUBuIcTGLCl.sExG0pjEKognh8oJ3yfOWL4G8ZOGMRjwyY6QduaC6 rZrYkkWYq4GwnL7kfZtCX0hfCi2YZ42Spw51ST2j_fsJTHizMRb0qJ1ii.R8Mm4iV8DW_r5a3d7v Bu9E1bKsoft5kVnHj0Av_St7U_5H7AoRVG_Cydq3td08aCsWJXgDvnnFv6xcQYo92pJJLsxE7psQ tg426pJXTVMzsva9eJjkqtDSIvNFAIoIAzHwpeGfrekBjYhKp5Y_8PKHniFMkyrmHAbOm668HAWV 2Tq8a577kF3g99Fz8T5iam6quOvDjxmhMkZUev5i6UVUE.t_v7dTpWCgvy1s7vNcgjdHT7Ncxt3g 7I7W3N2iuHDEvgn5a8X953LFCYXztjqqsFunSnad8GhdoxWq_To.cNkjJahxQ6h6KdRv2YAZNJyJ VddrSXT5u1ILXCO_hj2KUNlxzoHC..PnsQlJtAqDul74dcQKxRwnjQiCMW.6ebYW.RZwzErWxbCD Gw77bOgeOKHtRTR0h65eW6giqBk04uWp1tx4bt5gD.yffW_nxNeZRIf0lORfwhs19fdS5DYktmTl g44tJH1i0QHQK1hUk9TdBhMe07S0w6VheQSkjWGC1rlOjQaepBhoVR.0t5qh1d.G4S.auOU0QltV tFfrT3DGB0JLNK0tJepkZW85UiLSW4HIN6nuMBLHVflC8Q.1A4cBU8j8SkRctLKXLDF3prjVYsb4 1wWwU91CrB2vH9UP_BBJsbwyIroF.yctpRFGZuyRyxBDUt95oVTj4_aQgOdJMnsAMbsd1cdIxL25 D3LSeoygdM9ArkRkgw8C6tlUmoThMBEMD5CfxwxZUO2QHMKYTQpjmGcvQqqv_XOIAt2ugvZyjK7. jRhAwcyYWhGR.NxpnrPWm6vSv_8MqQEi3z8bHUQVVHFxsJiWNLSgv..6drvCrS3nwJ_TnC1s04nn AOm7IpJjopTszcQoE9mmdT17EJZze37Va7uZdeItA424PSscxTqejrjZHWS_QoRUVxR8Z5RfrWr_ GTK1sOrtbvtfQWJI3Oiv8xmrchnuJrydC_1Brwk5v1_998xJh_5xWs21gCAjio1HaGc3ebnzkSy3 XdLnRxaO3vqlWUMBByH29PHc5SnL_tgMvIXT61pUKBYP6vkL6NTR3Jdk1By1aQYb.BjldJoR4S4l qUG2KGYmaDBhOFKyWcOjIPGkwQy68wcygUv79pPgfV5oZQNRFQTcpt7EHV5U9BRihtf6mq5WUv5D xqAx3UQlF9VorX3.PGRB_pHCUA76d6EtqhGw8nkWt1JOJwQ3XRa0ed02R9jOBxQs4F9fBhOPy9b7 AFAA.SMQhP0t.OpnSdnMoEHxHuoSO3m_D1aR8o8PFsZAiEeGOrHwLtxvGP_nygx65BnkCLss0r7M dTyqRqXXWUANnDCuR9er1ekymjudsKWcQsHDz6tPWlQHYBIbAoBBJgdODEWJVWk1FGVHgnQblK_P PEJChJc4cVroaqJRzgaVzCx.ck98Yz_rcqaS_tQOMJUDVt9ud8y0ss8LDFf.qXD7yCGKxnLbOSFO efnS9C8f5NVuLMVcnL1_L08blRiHbaYtiKlPC7gaTFYIkheGlthbYPknx.Iwwq32J7bjHj2tRnaH X3pbAyHAM74htEy3z8qpk6HgYEBFCub_CPktrnnOQndlGAw7Q7aFyvxtRpfKXLYW_ElN8.jROtmz echRC5s8670g6Skm9UELzVCg3f9FFRm2.COJQ_4nL9UQyUQ1vzw4BbYCk6c0PQpciZ9JOspUN1R1 LXqkiZOEEc1Wucw-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.sg3.yahoo.com with HTTP; Thu, 8 Dec 2022 07:13:02 +0000 Date: Thu, 8 Dec 2022 07:13:01 +0000 (UTC) From: G Chandrasekar To: "pgsql-general@lists.postgresql.org" Message-ID: <1058362846.740040.1670483581746@mail.yahoo.com> Subject: Reading from replication slot fails if publication is dropped and created. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_740039_863191573.1670483581744" References: <1058362846.740040.1670483581746.ref@mail.yahoo.com> X-Mailer: WebService/1.1.20926 YMailNorrin Content-Length: 3533 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_740039_863191573.1670483581744 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,=C2=A0 Have a scenario, where the publication was accidentely deleted an= d eventhough the publication was re-created, trying to read data from the r= eplication slot fails with the following error message. "ERROR: publication \"dbz_publication\" does not exist\n Where: slot \"s20= d07aebf4204109872de556b66b0afb\", output plugin \"pgoutput\", in the change= callback, associated LSN 3D/717714F0" Aware that the publication would have to be created first and then the repl= ication slow should follow. Is there any way to have the system working wit= hout having to delete the replication slot and re-create all over? i.e crea= te publication and set the appropriate references ? Note; Restarted the db instance after re-creating the publication (presume = some internal model assocating the publication -> tables -> replication slo= t is broken). Appreciate thought/suggestions. Thanks. ------=_Part_740039_863191573.1670483581744 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
  Have a scenario, where the publication was accidentely deleted a= nd eventhough the publication was re-created, trying to read data from the = replication slot fails with the following error message.

=
"ERROR: publication \"dbz=
_publication\" does not exist\n  Where: slot \"s20d07aebf4204109872de556b66=
b0afb\", output plugin \"pgoutput\", in the change callback, associated LSN=
 3D/717714F0"

Aware that the publication would have to be created first and then the= replication slow should follow. Is there any way to have the system workin= g without having to delete the replication slot and re-create all over? i.e= create publication and set the appropriate references ?

= Note; Restarted the db instance after re-creating the publication (presume = some internal model assocating the publication -> tables -> replicati= on slot is broken).

<= div dir=3D"ltr" data-setdir=3D"false">Appreciate thought/suggestions.
=

Thanks.

=
------=_Part_740039_863191573.1670483581744--