Re: Service startup delay

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:[email protected]] 
Sent: Friday, August 20, 2004 4:09 PM
To: Bruce Momjian; Barry Lind
Cc: [email protected]; Max Dunn
Subject: RE: [pgsql-hackers-win32] Service startup delay

 

> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Bruce 
> Momjian
> Sent: 20 August 2004 19:00
> To: Barry Lind
> Cc: [email protected]; 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.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match