Postgresql errors on Windows with F-Secure AntiVirus
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.-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Nov 9, 2016 at 11:29 AM, Moreno Andreo <moreno.andreo@evolu-s.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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Nov 9, 2016 at 11:56 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Wed, Nov 9, 2016 at 11:29 AM, Moreno Andreo <moreno.andreo@evolu-s.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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general