public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ian Lawrence Barwick <[email protected]>
To: soumen rana <[email protected]>
Cc: [email protected]
Subject: Re: Anti virus scanning for Postgres database servers
Date: Tue, 23 Sep 2025 13:18:27 +0900
Message-ID: <CAB8KJ=jkvA+VhSYNR19c00TN0afQ+4TmyiW81UjhsaEgq=h+2g@mail.gmail.com> (raw)
In-Reply-To: <CA+nn5EVhtxMpoG64iKOMW2pSKEQGjpHbS3TiXg04HryXiETibg@mail.gmail.com>
References: <CA+nn5EVhtxMpoG64iKOMW2pSKEQGjpHbS3TiXg04HryXiETibg@mail.gmail.com>

2025年9月23日(火) 6:21 soumen rana <[email protected]>:
>
> Hi Everyone,
>
> The oganization I work for uses some postgres databases installed on Linux servers. The security team is planning to initiate Microsoft Defender Anti Virus scanning on these servers in an "Active" mode.
>
> This will mean that the Postgres Installation directories and files will be scanned by Microsoft Defender and quarantine any threats.
>
> We have requested to exclude the data directories from the Antivirus scanning.
> Is anyone aware of any performance,  operational, or data-loss related challenges with Anti Virus scanning of Postgres binaries?

I'm pretty sure I've worked on support cases in the past caused by
antivirus software doing things it shouldn't...

If the antivirus software in question modifies files in any way, it
will corrupt your PostgreSQL installation.
A few places warning against using antivirus software on PostgreSQL
data directories:

- https://www.highgo.ca/2021/01/27/avoiding-identifying-and-dealing-with-postgresql-database-corruptio...
- https://www.postgresql.eu/events/pgconfeu2023/sessions/session/4602/slides/406/data_corruption.pdf
- https://docs.microfocus.com/UCMDB/11.0/ucmdb-docs/docs/eng/doc_lib/Content/database/PostgresConfig_c...

Regards

Ian Barwick

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: Anti virus scanning for Postgres database servers
  In-Reply-To: <CAB8KJ=jkvA+VhSYNR19c00TN0afQ+4TmyiW81UjhsaEgq=h+2g@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