public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Devvrat Mittal <[email protected]>
Cc: [email protected]
Subject: Re: Wal Files not removing automatically
Date: Mon, 28 Apr 2025 07:08:55 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAN8+pfqikxnMgocorGbgsP08N4s6XJ8LJAT3advK6urZ29Xj2A@mail.gmail.com>
References: <CAN8+pfqikxnMgocorGbgsP08N4s6XJ8LJAT3advK6urZ29Xj2A@mail.gmail.com>
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
view thread (2+ messages)
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], [email protected]
Subject: Re: Wal Files not removing automatically
In-Reply-To: <[email protected]>
* 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