Starting PostgreSQL on Windows and recent possible Microsoft Security Manager update

From: Andrew Barnham <andrew(dot)barnham(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Starting PostgreSQL on Windows and recent possible Microsoft Security Manager update
Date: 2012-12-27 00:55:56
Message-ID: CAC9_YpbyA==yEw9xiDUo1RMDLZ_XpaYH8X-oMiCtEFhV8z-mbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Since the 24th I've been receiving reports from number of separate pg
install (8.4.7 and 8.4.2) that postgres is not automatically starting as a
service. Have about 15 sites affected; likely many more as people return
from holidays.

Digging around, problem happens on XP/Win7 32/64 I believe. common
denominator appears to be microsoft security essentials. Appears to be
some sort of race at boot time between MSE and postgresql. Postgresql will
pause in its start cycle until MSE goes through some sort of cycle which is
visually obvious because it flashes momentarily that computer is not
protected. If MSE takes longer than 30 seconds, pg service will not start
at all.

The following I've found so far work around the problem:

1) Manually starting pg after MSE 'warms up'. i.e. net start <service>

2) Disabling MSE Real-time protection.

Are people having similar experiences? Sorry for vague details, win
machines are not a core competency.

Andrew

Browse pgsql-bugs by date

  From Date Subject
Next Message Phil Sorber 2012-12-28 18:55:36 WAL Receiver Segmentation Fault
Previous Message Len Tanaka 2012-12-26 03:21:38 Re: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"