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

От

Rui DeSousa

Тема

Дата

9 февраля 2023 г. в 18:47:48

Msg-id

B88AE058-0049-40CB-AF4B-C807279127B0@crazybean.net

обсуждение

Ответ на

Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node (Tim)

Список

pgsql-admin

Дерево обсуждения

Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node Tim <timfosho@gmail.com> 9 февраля 2023 г. в 18:41:30

Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node Laurenz Albe <laurenz.albe@cybertec.at> 9 февраля 2023 г. в 20:10:27

Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node Rui DeSousa <rui@crazybean.net> 9 февраля 2023 г. в 18:47:48

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 по дате отправления

Предыдущее

От: Tim

Дата: 9 февраля 2023 г. в 18:41:30

Сообщение: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node

Следующее

От: Laurenz Albe

Дата: 9 февраля 2023 г. в 20:10:27

Сообщение: Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node