public inbox for [email protected]
help / color / mirror / Atom feedWal Files not removing automatically
2+ messages / 2 participants
[nested] [flat]
* Wal Files not removing automatically
@ 2025-04-28 07:18 Devvrat Mittal <[email protected]>
2025-04-28 11:08 ` Re: Wal Files not removing automatically Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Devvrat Mittal @ 2025-04-28 07:18 UTC (permalink / raw)
To: [email protected]
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Wal Files not removing automatically
2025-04-28 07:18 Wal Files not removing automatically Devvrat Mittal <[email protected]>
@ 2025-04-28 11:08 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2025-04-28 11:08 UTC (permalink / raw)
To: Devvrat Mittal <[email protected]>; +Cc: [email protected]
Devvrat Mittal <[email protected]> writes:
> 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?
The entire point of a replication slot is that it prevents WAL from
being discarded until whatever is supposed to read from the slot
has consumed that WAL. So apparently nothing is reading from that
slot, which means there is something wrong with the way
you've connected up your replication setup. I would have thought
you'd be using slots to feed your standby and witness servers
(and I don't understand why you don't have two slots, one for each).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-04-28 11:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-28 07:18 Wal Files not removing automatically Devvrat Mittal <[email protected]>
2025-04-28 11:08 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox