Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node

From: Rui DeSousa <rui(at)crazybean(dot)net>
To: Tim <timfosho(at)gmail(dot)com>
Cc: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Date: 2023-02-09 18:47:48
Message-ID: B88AE058-0049-40CB-AF4B-C807279127B0@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Feb 9, 2023, at 1:41 PM, Tim <timfosho(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-02-09 20:10:27 Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Previous Message Tim 2023-02-09 18:41:30 Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node