A Strange Qt and postgresql problem ! when using Kaspersky

Proton Phoenix

Windows 10 x64 almost latest update
Qt 5.15.2 as i remember
Hi ~~~ I Knew it's not the right place but i am sure most of qt user who are using postgresql have the same problem just they didn't notice it (it affect all softwares i have tested ..

I am QT C++ programmer Using postgresql as database server ...

my software use almost 23 mega of ram and that's ok for me

but when i switched to kaspersky internet security a new problem show up ~~! my software in a second after connecting to the host of (postgresql)
ram usage rise to almost 68.7 and sometimes to 87 mega ... those data from Task Manager ..

i can't understand how can kaspersky make postgresql return a memory leak to my softwares (only when connecting to the database)

that happen only when i am using kaspersky
i tried to uninstall it (kaspersky) and problem fixed .. and ram usage return to it's correct values ..
i don't know where the problem i am not an expert of windows api yet !
as i found kaspersky use postgresql too for some stuff ..

any idea How would this happen?
many thanks ...

Axel Spoerl

If everything is configured properly and you use pgsql > 10.7, the only idea I have is that Kaspersky (partly) blocks network traffic coming from an executable, which it doesn't know. But that's where my knowledge ends and you have to turn to the Kaspersky support.

Kent-Dorfman

any suggestion I can make would be based on conjecture...I use Qt and postgres much, but PyQt in Linux. We don't worry about virus checkers.

Axel Spoerl

The post makes me believe that there was a working setup without Kaspersky.

but when i switched to kaspersky

...was Kaspersky just added on top of a running system?
More specifically, Kaspersky doesn't like direct peer connections, which are postgres' default configuration.
In case you have an local all/all configuration in pg_hba.conf, it must be
host all all 127.0.0.1/32 md5(md5instead of peer).
Kaspersky scan engine requires postgres 10.7 or later.
If the scan engine is running on a different computer and you have not yet enabled external connections to postgres, the scanner has to be granted access by adding another line to pg_hba.conf:
host all all <your external IP>/32 md5

Since this is not a Qt related issue, you may want to check the postgres mailing lists and/or Kaspersky for additional support.

Proton Phoenix

@Axel-Spoerl said in A Strange Qt and postgresql problem ! when using Kaspersky:

...was Kaspersky just added on top of a running system?

Thank you so much bro , i knew it's not the right place just i want to understand how can security software return memory leak from database to all my softwares that's why i posted in this pro forum ~~-yep everything is in same computer , in pg_hba local and host too are md5 as you mentioned
the problem is when connecting to the host which is local it return memory leak to my software (only on connecting Queries works fine) from postgresql only under protection from kaspersky when i uninstall it problem solved
the problem happen only on this step under kaspersky
without kaspersky works great without any kind of issues


QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("******");
    db.setUserName(ui->userlineedit->text());
    db.setPassword(ui->passwordlineedit->text());
    db.setDatabaseName("something");

The same problem affected all of my test softwares

Axel Spoerl

If everything is configured properly and you use pgsql > 10.7, the only idea I have is that Kaspersky (partly) blocks network traffic coming from an executable, which it doesn't know. But that's where my knowledge ends and you have to turn to the Kaspersky support.

Proton Phoenix

@Axel-Spoerl said in A Strange Qt and postgresql problem ! when using Kaspersky:

If everything is configured properly and you use pgsql > 10.7, the only idea I have is that Kaspersky (partly) blocks network traffic coming from an executable, which it doesn't know. But that's where my knowledge ends and you have to turn to the Kaspersky support.

Thank You so much bro <3 for great support
by the way i am using postgresql version 14 the latest one

i agree with you there's a problem on kaspersky they partly affect any unsigned software when connecting to postgresql ... (kaspersky set my tested softwares as (low restricted which is the best group when application doesn't have digital signature) in application control

Low Restricted. This group includes applications for which the following conditions are met: Applications are not digitally signed by trusted vendors. Applications are not recorded in the trusted applications database of Kaspersky Security Network.