Re: Service startup delay - Mailing list pgsql-hackers-win32

Bruce,

I installed the build compiled on 8/21 (which I assume contains this patch)
and added the -w option, but it didn't solve the problem. The first two
reboots worked fine, but on the third reboot, the subsequent service
(Tomcat) started up before Postgres was ready. (Besides our applet not
starting, the postmaster.pid timestamp was 2 seconds after Tomcat started.)

Another issue is that when installing the Postgres service with "pg_ctl
register -w ...." the "-w" parameter was not put in the registry "ImagePath"
value for the Postgres service. (I added it manually to test.) So I suspect
that "pg_ctl register" will need to be enhanced to add the "-w" parameter to
the registry settings.

--Max

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Friday, August 20, 2004 8:12 PM
To: Max Dunn
Cc: 'Dave Page'; 'Barry Lind'; pgsql-hackers-win32@postgresql.org;
PostgreSQL-patches
Subject: Re: [pgsql-hackers-win32] Service startup delay


OK, I started running tests with pg_ctl -w and found it did not work even on
Unix.  I found that the code was not checking the return value of
PQsetdbLogin(), and wasn't looping properly using a sleep.

The attached applied patch should fix should fix your reported problem.

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

Max Dunn wrote:
> 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.
>
>
> ---------------------------(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
>

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