Re: Service startup delay

Barry Lind wrote:
> We are incorporating the win32 port into our product, and have run into
> a problem with the timing of the startup of the windows service.   What
> is happening is that we have setup a dependency between our service and
> the postgres service so that our service starts after the postgres one.
> However this sometimes still fails, as it appears the postgres service
> returns control to windows before the database is actually fully started
> and ready to accept connections as we are getting an error in our app
> (org.postgresql.util.PSQLException: A connection error has occurred:
> org.postgresql.util.PSQLException: FATAL: the database system is
> starting up).  Can this be fixed?  We can hack around this in our code,
> but it would be nice (and I am sure others will run into this as well)
> if this was fixed properly in the postgres service itself.

I think you need to use 'pg_ctl -w' to wait for it to start.

--
  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