Re: Service startup delay
От | Max Dunn |
---|---|
Тема | Re: Service startup delay |
Дата | |
Msg-id | 200408240201.i7O21qJ16051@IPOfCard1.guest-tek.com обсуждение исходный текст |
Ответ на | Service startup delay ("Barry Lind" <blind@xythos.com>) |
Ответы |
Re: Service startup delay
(Bruce Momjian <pgman@candle.pha.pa.us>)
|
Список | 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
В списке pgsql-hackers-win32 по дате отправления: