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 CAMa1XUhS=UfEG1X2LnpDLRqw84eC+2iGAXmEnjOh2sZrz8XxFA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL logical replication depends on WAL segments?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PostgreSQL logical replication depends on WAL segments?
List 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 by date:

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