Looking at the two patches I just applied I think it might fix your
problem. The problem was actually the general problem of pg_ctl -w start
not returning a non-zero.

---------------------------------------------------------------------------

Steve McWilliams wrote:
> Hello,
> 
> I tried sending this the other week but for some reason it hasn't gone
> through, so I am resending:
> 
> I am using Postgresql-8.0.0beta4 on Windows XP Pro and have noticed that
> attempts to run pg_ctl as a service fail when the "-w" option is included.
>  So if I register the service as follows:
> 
> pg_ctl.exe -N my_svc -w -U my_user -P my_pword -D my_dir -o "-i -p 15432"
> 
> then try to start the service via the GUI service manager panel, it pops
> up an error dialog saying the service started but then stopped
> immediately.  If I remove the "-w" option from the above line when it is
> registered, then I am able to start the service just file.
> 
> The usage documentation for pg_ctl indicates you are supposed to be able
> to include the "-w" option when you register it as a service.  I would
> like to be able to use it, so that when Windows launches postgres, it is
> not declared to be in the fully running state prematurely.  We have
> another service that we launch which declares a dependency on postgres,
> however that dependency declaration is meaningless if postgres announces
> that it is fully running before it is truly able to accept clients.
> 
> Any suggestions?  For a temporary work around I have hacked my pg_ctl.c to
> wait 5 seconds before declaring the service to be in the running state. 
> Thanks in advance.
> 
> Steve McWilliams
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> 

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to