From: hubert depesz lubaczewski <depesz@depesz.com>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: amit.kapila16@gmail.com
Cc: pgsql-bugs@postgresql.org
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Date: Mon, 17 Oct 2022 11:14:32 +0200
Message-ID: <Y00c+IlaWSHGNbnz@depesz.com> (raw)
In-Reply-To: <20221017.155307.3782702886583901.horikyota.ntt@gmail.com>
References: <Yz2hivgyjS1RfMKs@depesz.com>
<CAA4eK1JTE0tLgR5qzVECrKJV5VVTnDa0k5LQ4TOkBAA=MySj3g@mail.gmail.com>
<20221017.155307.3782702886583901.horikyota.ntt@gmail.com>
On Mon, Oct 17, 2022 at 03:53:07PM +0900, Kyotaro Horiguchi wrote:
> Anyway, I didn't come up with a possibility other than of someone else
> having removed those files.. For example, virus scan softwares. If
> any such software kills processes that is grabbing the files that the
> software identified as malicious and is going to remove, that could be
> happen?
We don't use virus scanning there. The pg12 server is on ubuntu 18.04,
used for normal production workload, and pg14 is on ubuntu focal, with
no load, aside from 2 physical streaming replication to pg14 replicas.
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, horikyota.ntt@gmail.com, amit.kapila16@gmail.com
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
In-Reply-To: <Y00c+IlaWSHGNbnz@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