Sunday, June 18, 2017

Windows Defender Interferes with PostgreSQL on Windows 10

I am running a PostgreSQL database server on a Windows 10 host for development. I noticed that Windows Defender sometimes interferes with PostgreSQL and results the PostgreSQL services being terminated.

More specifically,  when you have a database transaction running and the Windows Defender starts to scan, the Windows Defender would label PostgreSQL transaction log as a threat as illustrated in the screenshot captured below. It shows that Windows Defender labels a PostgreSQL transaction log as a "Exploit:HTML/IframeRef", which is clearly a false alarm. Windows Defender would next quarantines the threat and the transaction log becomes inaccessible to the PostgreSQL service.


If you examine services in the Windows 10 host, you will see that the PostgreSQL service is terminated as illustrated in the screenshot below. At this time, any query to the PostgreSQL database results in failure.


The solution is to exclude the PostgreSQL transaction log directory from Windows Defender's scan. Microsoft explains how this can be done in this page.

7 comments:

  1. It is really a helpful blog to find some different source to add my knowledge. I came into aware of new professional blog and I am impressed with suggestions of author.
    สแกนเอกสาร

    ReplyDelete
    Replies
    1. Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download Now

      >>>>> Download Full

      Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download LINK

      >>>>> Download Now

      Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download Full

      >>>>> Download LINK 4c

      Delete
  2. how to-How to set up Windows Defender Scheduled Scan The Windows Defender Antivirus is an excellent tool which can be managed to scan

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. great work buddy, But we also use gpedit to remove windows defender read how to remove windows defender

    ReplyDelete
  5. Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. Windows 10

    ReplyDelete
  6. Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download Now

    >>>>> Download Full

    Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download LINK

    >>>>> Download Now

    Notes Of A Programmer: Windows Defender Interferes With Postgresql On Windows 10 >>>>> Download Full

    >>>>> Download LINK Zs

    ReplyDelete