| From: | Jeremy Finzel <finzelj(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Josef Machytka <josef(dot)machytka(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL logical replication depends on WAL segments? |
| Date: | 2019-01-22 18:59:06 |
| Message-ID: | CAMa1XUhstcBJ_b0po3nn3vdY15Yrxu_3TW-oe9CmtxoUkxSR_A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 22, 2019 at 12:52 PM Andres Freund <andres(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Finzel | 2019-01-22 19:03:35 | Re: PostgreSQL logical replication depends on WAL segments? |
| Previous Message | Andres Freund | 2019-01-22 18:53:49 | Re: PostgreSQL logical replication depends on WAL segments? |