Re: Anti virus scanning for Postgres database servers

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: soumen rana <soumenrana(dot)06(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Anti virus scanning for Postgres database servers
Date: 2025-09-23 12:03:12
Message-ID: aNKMgEKo8VDq0mId@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Sep 23, 2025 at 08:22:51AM +0200, Laurenz Albe wrote:
> On Mon, 2025-09-22 at 13:03 -0700, soumen rana wrote:
> > 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 think that should be safe, at least until Microsoft starts to perceive
> PostgreSQL as a threat...

Uh, if the anti-virus software does not modify any files, you are likely
to get false positives when the antivirus software thinks Postgres data
is a virus. If the anti-virus software modifies the data directory in
any way, you are likely to get database corruption or a non-operational
database.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message srinivasan s 2025-09-23 12:47:03 Re: Anti virus scanning for Postgres database servers
Previous Message Laurenz Albe 2025-09-23 06:38:23 Re: Vacuum Question