public inbox for [email protected]  

help / color / mirror / Atom feed

From: Devvrat Mittal <[email protected]>
To: [email protected]
Subject: Wal Files not removing automatically
Date: Mon, 28 Apr 2025 12:48:15 +0530
Message-ID: <CAN8+pfqikxnMgocorGbgsP08N4s6XJ8LJAT3advK6urZ29Xj2A@mail.gmail.com> (raw)

Hello,

I have 3 nodes on which i have configured repmgr on 1st node primary, on
2nd standby and on 3rd witness. I have also configured pgbackrest on the
primary and witness node.
I'm using fivetran as a replication slot. i have also set the parameters
which are:
wal_level = 'logical'
synchronous_commit = local
wal_log_hints = 'on'
archive_mode = on
max_wal_senders = 10
wal_keep_segments = 32
max_replication_slots = 10
hot_standby = on
wal_sender_timeout = 300s
wal_receiver_timeout = 300s
max_connections = 1000
shared_buffers = 15GB
effective_cache_size = 45GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 3932kB
min_wal_size = 2GB
max_wal_size = 8GB

And these parameters also set on the other sites too. Now the issue is the
wal files are removing automatically. And the restart_lsn is also not
changing automatically. But when i drop the replication slot and recreate
it. After i create the replication slot the restart_lsn change but after
that i face the same issue that restart_lsn is not changing. So i wanna
know is it kind of bug or it's a issue from from database side?

view thread (2+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Wal Files not removing automatically
  In-Reply-To: <CAN8+pfqikxnMgocorGbgsP08N4s6XJ8LJAT3advK6urZ29Xj2A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox