Re: PostgreSQL logical replication depends on WAL segments?

Поиск
Список
Период
Сортировка
От Josef Machytka
Тема Re: PostgreSQL logical replication depends on WAL segments?
Дата
Msg-id CAGvVEFsOCCi7xHWtXsDQ4mb9VVYB3TrKgpq+6i8JHkNPBw_TXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical replication depends on WAL segments?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?