Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL logical replication depends on WAL segments? - Mailing list pgsql-general

From Jeremy Finzel
Subject Re: PostgreSQL logical replication depends on WAL segments?
Date
Msg-id CAMa1XUhstcBJ_b0po3nn3vdY15Yrxu_3TW-oe9CmtxoUkxSR_A@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL logical replication depends on WAL segments?  (Andres Freund <andres@anarazel.de>)
Responses Re: PostgreSQL logical replication depends on WAL segments?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: PostgreSQL logical replication depends on WAL segments?
Next
From: Jeremy Finzel
Date:
Subject: Re: PostgreSQL logical replication depends on WAL segments?