From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql errors on Windows with F-Secure AntiVirus |
Date: | 2016-11-09 18:58:09 |
Message-ID: | CAOR=d=0kjoPtKk4zDUGn2zH8aASLBxok4dJrp8RHyVCPPde00A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Nov 9, 2016 at 11:56 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Nov 9, 2016 at 11:29 AM, Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> wrote:
>> Hi again,
>> our support team is reporting cases where postgres connections are
>> suddenly dropped, but reconnecting again soon everyting is OK.
>> Environment is PostgreSQL 9.1 on Windows (various versions)
>> Asfer some research, I found on postgresql log many of these messages
>> could not reserve shared memory region (addr=02E80000) for child 0000094C:
>> 487
>> Searching the archives I found a bug fixed with 9.3.x, since I had 9.1, I
>> migrated to 9.5.6 (standard for new installations). After restarting, I got
>> the exact same error and response behaviour.
>> After another search, I stopped F-Secure Antivirus services, and everything
>> is now going smoothly. So, with the help of a mate that knows how this
>> antivirus work, we put exceptions to all PostgreSQL directories.
>> After restarting, the error was back. Nothing in the AV log. Tomorrow we'll
>> try with adding exclusions to port 5433....
>>
>> Someone else facing this problem?
>>
>> Thanks
>> Moreno.-
>
>
> Shared memory doesn't come from a file on teh hard drive. You need an
> exception for whatever postgres uses for shared memory in windows. I
> don't know much about pgsql on windows, but that should get you
> started.
>
>
> Post back if you find anything that makes it work.
>
Oh and if you can report it to the antivirus vendor so they can fix it
permanently on their end. pgsql is not a virus.
From | Date | Subject | |
---|---|---|---|
Next Message | Fran ... | 2016-11-09 19:05:23 | Role and grants |
Previous Message | Scott Marlowe | 2016-11-09 18:56:55 | Re: Postgresql errors on Windows with F-Secure AntiVirus |