Skip site navigation (1) Skip section navigation (2)

Re: Service startup delay

From: "Max Dunn" <mdunn(at)xythos(dot)com>
To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>,"'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>,"'Barry Lind'" <blind(at)xythos(dot)com>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Service startup delay
Date: 2004-08-21 02:45:07
Message-ID: NSNOVPS004119eqwZ2c00001c92@NSNOVPS00411.nacio.xythos.com (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-patches
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(at)vale-housing(dot)co(dot)uk] 
Sent: Friday, August 20, 2004 4:09 PM
To: Bruce Momjian; Barry Lind
Cc: pgsql-hackers-win32(at)postgresql(dot)org; Max Dunn
Subject: RE: [pgsql-hackers-win32] Service startup delay

 

> -----Original Message-----
> From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of Bruce 
> Momjian
> Sent: 20 August 2004 19:00
> To: Barry Lind
> Cc: pgsql-hackers-win32(at)postgresql(dot)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.


In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-08-21 02:59:49
Subject: Re: Service startup delay
Previous:From: Dave PageDate: 2004-08-20 23:08:30
Subject: Re: Service startup delay

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-08-21 02:59:49
Subject: Re: Service startup delay
Previous:From: Dave PageDate: 2004-08-20 23:08:30
Subject: Re: Service startup delay

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group