Re: PostgreSQL logical replication depends on WAL segments?

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: PostgreSQL logical replication depends on WAL segments?
Дата
Msg-id CAMa1XUhstcBJ_b0po3nn3vdY15Yrxu_3TW-oe9CmtxoUkxSR_A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical replication depends on WAL segments?  (Andres Freund <andres@anarazel.de>)
Ответы Re: PostgreSQL logical replication depends on WAL segments?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Jan 22, 2019 at 12:52 PM Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2019-01-22 11:10:27 -0600, Jeremy Finzel wrote:
> P.S. do heed the advice of the others and get more familiar with the docs
> around WAL archiving.

Logical replication doesn't normally interact with WAL archiving in any
way, so that seems orthogonal.

But he is manually removing WAL files via cron which should normally be held until the replication slot doesn't need it anymore.  I do believe that is why he is getting errors.  The suggestion is to rely on Postgres' WAL archiving rather than removing WAL files manually...

Thanks,
Jeremy 

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

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