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

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Дата
Msg-id B88AE058-0049-40CB-AF4B-C807279127B0@crazybean.net
обсуждение исходный текст
Ответ на Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node  (Tim <timfosho@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tim
Дата:
Сообщение: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Cascading Replication - Standby Recovering Faster from Archive rather than Upstream node