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

From Josef Machytka
Subject Re: PostgreSQL logical replication depends on WAL segments?
Date
Msg-id CAGvVEFsOCCi7xHWtXsDQ4mb9VVYB3TrKgpq+6i8JHkNPBw_TXA@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?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: PostgreSQL logical replication depends on WAL segments?  (Jeremy Finzel <finzelj@gmail.com>)
List pgsql-general


Thanks, I see... So if I understand it correctly - since I have quite big partitions like ~30 GB each in one parent table and from ~1GB to ~5 GB in several others I presume I had to set wal_keep_segments to some really high number and stop our security cronjob cleaning old WAL segments (because we already had some problems with almost full disk due to old WAL segments) until the whole transfer of snapshot is done. Because only after the whole snapshot is transferred logical replication workers start to transfer WAL logs reflecting changes done from the moment snapshot was taken...

jm

pgsql-general by date:

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