Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Date
Msg-id B88AE058-0049-40CB-AF4B-C807279127B0@crazybean.net
Whole thread Raw
In response to Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node  (Tim <timfosho@gmail.com>)
List pgsql-admin


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.

pgsql-admin by date:

Previous
From: Tim
Date:
Subject: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Next
From: Laurenz Albe
Date:
Subject: Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node