Re: Postgresql errors on Windows with F-Secure AntiVirus

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.

--
To understand recursion, one must first understand recursion.