From: hubert depesz lubaczewski <depesz@depesz.com>
To: Andres Freund <andres@anarazel.de>
Cc: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Date: Thu, 17 Nov 2022 11:26:57 +0100
Message-ID: <Y3YMcdBQEBgGwq+Y@depesz.com> (raw)
In-Reply-To: <20221117072512.q3fayfyd5ugfwvmf@awork3.anarazel.de>
References: <Yz2hivgyjS1RfMKs@depesz.com>
<CAA4eK1JTE0tLgR5qzVECrKJV5VVTnDa0k5LQ4TOkBAA=MySj3g@mail.gmail.com>
<Y00cp4sNQtFNoo25@depesz.com>
<CAA4eK1KUMFfVrOpP7VgAPUN7rabvfr5GhcQh++T8BX-t7=e5YA@mail.gmail.com>
<Y0/bSiDkYlhiSmOW@depesz.com>
<Y1E3JIFqb0mFBZNR@depesz.com>
<Y25hQCKLnolQaFN9@depesz.com>
<20221117072512.q3fayfyd5ugfwvmf@awork3.anarazel.de>
On Wed, Nov 16, 2022 at 11:25:12PM -0800, Andres Freund wrote:
> Perhaps a stupid question - are you using max_slot_wal_keep_size? And what's
> your wal_segment_size? And wal_keep_size?
Are we talking about pg12 side?
=> select name, setting from pg_settings where name ~ 'wal';
name │ setting
══════════════════════════════╪═══════════
max_wal_senders │ 50
max_wal_size │ 49152
min_wal_size │ 256
wal_block_size │ 8192
wal_buffers │ 2048
wal_compression │ on
wal_consistency_checking │
wal_init_zero │ on
wal_keep_segments │ 1000
wal_level │ logical
wal_log_hints │ off
wal_receiver_status_interval │ 10
wal_receiver_timeout │ 60000
wal_recycle │ on
wal_retrieve_retry_interval │ 5000
wal_segment_size │ 16777216
wal_sender_timeout │ 60000
wal_sync_method │ fdatasync
wal_writer_delay │ 200
wal_writer_flush_after │ 128
(20 rows)
max_slot_wal_keep_size was added in pg13, afaik. and wel_keep_* was
_segments in pg 12.
Best regards,
depesz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: depesz@depesz.com, andres@anarazel.de, horiguchi.kyotaro@lab.ntt.co.jp, amit.kapila16@gmail.com
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
In-Reply-To: <Y3YMcdBQEBgGwq+Y@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox