Postgres Pro
Downloads
Home   >   mailing lists

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

From Achilleas Mantzios
Subject Re: PostgreSQL logical replication depends on WAL segments?
Date
Msg-id 933d9b89-ce67-6982-3c03-240a27e5d35d@matrix.gatewaynet.com
Whole thread Raw
In response to Re: PostgreSQL logical replication depends on WAL segments?  (Jeremy Finzel <finzelj@gmail.com>)
List pgsql-general
Tree view
On 23/1/19 5:26 π.μ., Jeremy Finzel wrote:
On Tue, Jan 22, 2019 at 8:19 PM Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:


On 22/1/19 10:18 μ.μ., Jeremy Finzel wrote:
On Tue, Jan 22, 2019 at 2:16 PM Jeremy Finzel <finzelj@gmail.com> wrote:

any one of those WAL files will not be archived and recycled as long as it no longer needed by a replication slot


:(.  s/no longer/still.  I meant to say any one of those WAL files will not be archived and recycled as long as it still needed by a replication slot.


A WAL segment will be archived as soon as it is completed. https://www.postgresql.org/docs/11/continuous-archiving.html


Yep, you’re right. Let me try this again. It will be archived, but the segment won’t be reused or removed as long as the slot needs it. Is that an accurate statement?
That's better :) Also it depends on the previous checkpoint.


Thanks,
Jeremy 



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

pgsql-general by date:

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