Re: Service startup delay

Max Dunn wrote:
> Bruce,
>
> I installed the build compiled on 8/21 (which I assume contains this patch)

The patch was applied around midnight on 8/21 so I suggest you try an
newer download.  I wish I could give you an easy to see if the -w is
working but I can't on Win32.  On unix I changed the system call to do
"sh -c "sleep 40; postmastger ..." &  but that doesn't work on Win32.

If you have source put a sleep call at the top of the postmaster code
and see if the -w hangs printing does while waiting for the system to
start.


> and added the -w option, but it didn't solve the problem. The first two
> reboots worked fine, but on the third reboot, the subsequent service
> (Tomcat) started up before Postgres was ready. (Besides our applet not
> starting, the postmaster.pid timestamp was 2 seconds after Tomcat started.)
>
> Another issue is that when installing the Postgres service with "pg_ctl
> register -w ...." the "-w" parameter was not put in the registry "ImagePath"
> value for the Postgres service. (I added it manually to test.) So I suspect
> that "pg_ctl register" will need to be enhanced to add the "-w" parameter to
> the registry settings.

Would a Win32 guy look at this?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073