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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073