Re: PostgreSQL logical replication depends on WAL segments?

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: PostgreSQL logical replication depends on WAL segments?
Дата
Msg-id CAMa1XUhS=UfEG1X2LnpDLRqw84eC+2iGAXmEnjOh2sZrz8XxFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical replication depends on WAL segments?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: PostgreSQL logical replication depends on WAL segments?  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
That is news to me. Can you provide a citation for this?

I can see the confusion in what I said.  To clarify, I really meant that in order to retrieve that data that you need in really old WAL segments, you need to keep your replication slot in a position that will hold that WAL in place.  And that is what will prevent old rows from being vacuumed away.  There is no way to create a replication slot in the past, so the only way to actually use the old WAL for logical replication is to have an old slot in place with an LSN position from that long time ago.

The bit about rows not being removed is found here:

Thanks,
Jeremy

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

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