I tried adding the "-w" option to the registry entry for starting the
Postgres service(see below) but it didn't help; Tomcat still started before
Postgres was ready:
c:\Program Files\Xythos\WebFile Server Evaluation\pgsql\bin>sc qc postgresql
[SC] GetServiceConfig SUCCESS
SERVICE_NAME: postgresql
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 2 AUTO_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : C:/Program Files/Xythos/WebFile Server
Evaluation/p
gsql/bin/pg_ctl.exe runservice -w -N "PostgreSQL" -D "C:/Program
Files/Xythos/We
bFile Server Evaluation/pgsql/data" -o "-i"
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : PostgreSQL
DEPENDENCIES : RPCSS
SERVICE_START_NAME : .\postgres
--Max
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Friday, August 20, 2004 4:09 PM
To: Bruce Momjian; Barry Lind
Cc: pgsql-hackers-win32@postgresql.org; Max Dunn
Subject: RE: [pgsql-hackers-win32] Service startup delay
> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf Of Bruce
> Momjian
> Sent: 20 August 2004 19:00
> To: Barry Lind
> Cc: pgsql-hackers-win32@postgresql.org; Max Dunn
> Subject: Re: [pgsql-hackers-win32] Service startup delay
>
>
> I think you need to use 'pg_ctl -w' to wait for it to start.
>
Does -w work when starting in service mode? Aside from that, one possible
problem with this is what happens if the database goes into recovery mode at
startup. Whilst waiting for that to run, I would think it's possible that
the service control manager would timeout waiting for the service to
complete startup.
Regards, Dave.