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 ) id 1rVCfU-00FTXD-IB for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Jan 2024 15:38:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rVCfR-00Ev8z-Fm for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Jan 2024 15:38:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rVCfP-00Ev8q-LA for pgsql-hackers@lists.postgresql.org; Wed, 31 Jan 2024 15:38:25 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rVCfL-004jdl-AC for pgsql-hackers@lists.postgresql.org; Wed, 31 Jan 2024 15:38:23 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 38CB03200A70; Wed, 31 Jan 2024 10:38:14 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute2.internal (MEProxy); Wed, 31 Jan 2024 10:38:15 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1706715493; x=1706801893; bh=X2ITyQYX1o 2PzJappTJkJZHyC4cfkkVwnH2pTiwk+WY=; b=N1ElZeZpY6tw7GgfFAuA0iMxTN eaIigrRrRZaaAjl00v6DQxTgjo2skc9VaZJea22kVyoO/xvISyawUX3n66ZkHYpB OkbICvkyNksm/uTntpo3sC+8fNS9EFoF4OaRJJHSs4stXuUOHdqGN1y4mTfpmn0q cA2VNf7mAJ9Ca56SKOc8u8IsAa7yWJU0goyLp21/9KFAG5692fdaQ4AB6yJGLYzU q2yS8YXk/4N4YagTMaSOCM/jp/eMVFi+EUkJoiiz6ZJOAQrKMCrzAb+tQhxH6RlT SA0XG3bo+76K3n10O3/RGWM6JGOWlVYWj0b5DE7FcA2kjKMBMeTFtSoWSbxg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1706715493; x=1706801893; bh=X2ITyQYX1o2PzJappTJkJZHyC4cf kkVwnH2pTiwk+WY=; b=juSnhs6oRFbkDun89UV9XRGkwDIdPaqBzN7RvGvQJObL b1xJSNws5eO0Cp7NsviR/+8r1xwRk+fU83dec9c8HYCkWu4wNTcIiPaFYEVc4J1J HWmd4j9+T+rNfUk4ZQTot2ypvbhnQf/vVFA/QEtlOEt2hUi0Qgqkg+VV3fJsbBNr cwickJAROvt27+KS/lYjQ51gYEIW65AHLxgijDnMp1C08EHttjxTd0lEei3xMqem xtrvBs1BgRI25NbP4IYHK7Q4pTrxQKFCMlw/08d0ABmu0MNhxSQgew8DYbhyylAm EUwtmjJh0BLSKMtPzSjed6WONy7lvQASKjqJYUvG4w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrfedtledgjeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvfevufgtsegrtderreerreejnecuhfhrohhmpedfgfhu lhgvrhcuvfgrvhgvihhrrgdfuceovghulhgvrhesvghulhgvrhhtohdrtghomheqnecugg ftrfgrthhtvghrnhepgeeugeelheefheegvefggffhgffgteeuudevvdekhedvvdekgfeh keeitedvgedvnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegvuhhlvghrsegv uhhlvghrthhordgtohhm X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 52A0215A0092; Wed, 31 Jan 2024 10:38:13 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.11.0-alpha0-144-ge5821d614e-fm-20240125.002-ge5821d61 MIME-Version: 1.0 Message-Id: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com> In-Reply-To: References: <5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com> <4710d895-689a-4ae6-b8e3-344286dbf970@app.fastmail.com> <96e3b739-d63d-4d35-90a3-7869465b7167@eisentraut.org> <2736443c-58e3-42df-8cc4-8c66106e3da5@app.fastmail.com> <1cd45c1e-8ed1-42fc-9357-f1c43e0d6ac8@app.fastmail.com> <9b2256ea-484d-404d-a3cf-b8e86674951e@app.fastmail.com> Date: Wed, 31 Jan 2024 12:37:52 -0300 From: "Euler Taveira" To: =?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= Cc: "kuroda.hayato@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" , "vignesh C" , "Michael Paquier" , "Peter Eisentraut" , "Andres Freund" , "Ashutosh Bapat" , "Amit Kapila" , "Shlok Kyal" Subject: Re: speed up a logical replica setup Content-Type: multipart/alternative; boundary=eed08e22c306467690da3b1b5d1e474d List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --eed08e22c306467690da3b1b5d1e474d Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable On Wed, Jan 31, 2024, at 11:55 AM, Fabr=C3=ADzio de Royes Mello wrote: >=20 > On Wed, Jan 31, 2024 at 11:35=E2=80=AFAM Euler Taveira wrote: > > > > On Wed, Jan 31, 2024, at 11:25 AM, Fabr=C3=ADzio de Royes Mello wrot= e: > > > > Jumping into this a bit late here... I'm trying a simple pg_createsu= bscriber but getting an error: > > > > > > Try v11. It seems v12-0002 is not correct. >=20 > Using v11 I'm getting this error: >=20 > ~/pgsql took 22s=20 > =E2=9C=A6 =E2=9E=9C pg_createsubscriber -d fabrizio -r -D /tmp/replica= 5434 -S 'host=3D/tmp port=3D5434' -P 'host=3D/tmp port=3D5432' > NOTICE: changed the failover state of replication slot "pg_createsubs= criber_16384_706609" on publisher to false > pg_createsubscriber: error: could not drop replication slot "pg_create= subscriber_706609_startpoint" on database "fabrizio": ERROR: replicatio= n slot "pg_createsubscriber_706609_startpoint" does not exist > Write-ahead log reset Hmm. I didn't try it with the failover patch that was recently applied. = Did you have any special configuration on primary? -- Euler Taveira EDB https://www.enterprisedb.com/ --eed08e22c306467690da3b1b5d1e474d Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: quoted-printable
On Wed, Jan 31,= 2024, at 11:55 AM, Fabr=C3=ADzio de Royes Mello wrote:

=
On Wed, Jan 31, 2024 at 11:35=E2=80=AFAM Euler Taveira <euler@eulerto.com> wrote:
>
> On Wed, Jan 31, 2024, at 11:25 AM, Fabr=C3=ADz= io de Royes Mello wrote:
>
> Jumping i= nto this a bit late here... I'm trying a simple pg_createsubscriber but = getting an error:
>
>
&g= t; Try v11. It seems v12-0002 is not correct.

Using v11 I'm getting this error:

~= /pgsql took 22s
=E2=9C=A6 =E2=9E=9C pg_createsubscriber -= d fabrizio -r -D /tmp/replica5434 -S 'host=3D/tmp port=3D5434' -P 'host=3D= /tmp port=3D5432'
NOTICE:  changed the failover state= of replication slot "pg_createsubscriber_16384_706609" on publisher to = false
pg_createsubscriber: error: could not drop replicati= on slot "pg_createsubscriber_706609_startpoint" on database "fabrizio": = ERROR:  replication slot "pg_createsubscriber_706609_startpoint" do= es not exist
Write-ahead log reset

Hmm. I didn't try it with the failover pa= tch that was recently applied. Did you
have any special co= nfiguration on primary?


--
Euler Taveira
EDB   https://www.enterprisedb.com/=

--eed08e22c306467690da3b1b5d1e474d--