Re: PostgreSQL logical replication depends on WAL segments?

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: PostgreSQL logical replication depends on WAL segments?
Дата
Msg-id CAMa1XUgxHQcp_ORF6ru0CGFqVtL=nPKmT8-6LR9iSrB8+PVYKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical replication depends on WAL segments?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: PostgreSQL logical replication depends on WAL segments?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
On Tue, Jan 22, 2019 at 8:19 PM Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:


On 22/1/19 10:18 μ.μ., Jeremy Finzel wrote:
On Tue, Jan 22, 2019 at 2:16 PM Jeremy Finzel <finzelj@gmail.com> wrote:

any one of those WAL files will not be archived and recycled as long as it no longer needed by a replication slot


:(.  s/no longer/still.  I meant to say any one of those WAL files will not be archived and recycled as long as it still needed by a replication slot.


A WAL segment will be archived as soon as it is completed. https://www.postgresql.org/docs/11/continuous-archiving.html


Yep, you’re right. Let me try this again. It will be archived, but the segment won’t be reused or removed as long as the slot needs it. Is that an accurate statement?

Thanks,
Jeremy 

В списке pgsql-general по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?