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 1pQBxa-0005vn-F3 for pgsql-admin@arkaria.postgresql.org; Thu, 09 Feb 2023 18:47:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQBxZ-0003Am-CJ for pgsql-admin@arkaria.postgresql.org; Thu, 09 Feb 2023 18:47:53 +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 1pQBxZ-00033t-1B for pgsql-admin@lists.postgresql.org; Thu, 09 Feb 2023 18:47:53 +0000 Received: from impout008aa.msg.chrl.nc.charter.net ([47.43.20.32] helo=impout008.msg.chrl.nc.charter.net) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQBxW-0005MU-QJ for pgsql-admin@postgresql.org; Thu, 09 Feb 2023 18:47:51 +0000 Received: from cerberus.crazybean.net ([71.11.29.254]) by cmsmtp with ESMTP id QBxUpnPOuTuGEQBxVp3c6K; Thu, 09 Feb 2023 18:47:49 +0000 Authentication-Results: crazybean.net; none X-Authority-Analysis: v=2.4 cv=aruhtAVV c=1 sm=1 tr=0 ts=63e53fd5 a=GkUsAQdcAzAk0MT19QAIRQ==:117 a=GkUsAQdcAzAk0MT19QAIRQ==:17 a=xqWC_Br6kY4A:10 a=m04uMKEZRckA:10 a=pGLkceISAAAA:8 a=yVQG_HpYIHohUw9EsR8A:9 a=CjuIK1q_8ugA:10 a=T07ldBTCanVt86R41UUA:9 a=GoEzpzOMl6zog6z-:21 a=_W_S_7VecoQA:10 a=lqcHg5cX4UMA:10 Received: from smtpclient.apple ( [2001:470:e117:8:a4ac:aa31:ee2a:ec96]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 7554321f (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Thu, 9 Feb 2023 13:47:48 -0500 (EST) From: Rui DeSousa Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_45C497B6-B43F-432D-A4A1-D95546DE42A1" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.2\)) Subject: Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node Date: Thu, 9 Feb 2023 13:47:48 -0500 In-Reply-To: Cc: posgres support To: Tim References: X-Mailer: Apple Mail (2.3696.120.41.1.2) X-CMAE-Envelope: MS4xfCVhd6eI15p6+avd6oTpknQqEuTCH3tR0Unj6bU9g9egtTsx+7FCUgZ8BnnR+SGsuVeOhVN3cthwxLZHMmNEA3gGEkOUouSGCSGq4pDZgELZ8SIRyZBo +At6C5lsYhDv5+frJSogGIJCO4ErLmG6BgErs0ljswLxxzxABjMLWDhkaOk0PeL56d2chIllOtEPIddYkK31C2mPX2MDTTTQ0f7iaGJB/YrN98GNwitVKOIr List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_45C497B6-B43F-432D-A4A1-D95546DE42A1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On Feb 9, 2023, at 1:41 PM, Tim wrote: >=20 > Is there anything I can do to force to WAL stream instead of = recovering from the archive without removing the restore_command = setting? Yes, you can use a replication slot to ensure that the WAL file is = available on the primary until the DR node consumes it. You have to = make sure you have enough WAL free space to accommodate any lag or = disruption issues.= --Apple-Mail=_45C497B6-B43F-432D-A4A1-D95546DE42A1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

On Feb 9, 2023, at 1:41 PM, Tim <timfosho@gmail.com> = wrote:

Is there anything I can do to = force to WAL stream instead of recovering from the archive without = removing the restore_command setting?

Yes, you can use a replication slot to ensure = that the WAL file is available on the primary until the DR node consumes = it. You have to make sure you have enough WAL free space to = accommodate any lag or disruption issues.

= --Apple-Mail=_45C497B6-B43F-432D-A4A1-D95546DE42A1--