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

Re: Service startup delay

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Max Dunn <mdunn(at)xythos(dot)com>
Cc: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>,"'Barry Lind'" <blind(at)xythos(dot)com>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Service startup delay
Date: 2004-08-26 01:44:20
Message-ID: 200408260144.i7Q1iKR20607@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-patches
Max Dunn wrote:
> Bruce,
> 
> I installed the build compiled on 8/21 (which I assume contains this patch)

The patch was applied around midnight on 8/21 so I suggest you try an
newer download.  I wish I could give you an easy to see if the -w is
working but I can't on Win32.  On unix I changed the system call to do
"sh -c "sleep 40; postmastger ..." &  but that doesn't work on Win32.

If you have source put a sleep call at the top of the postmaster code
and see if the -w hangs printing does while waiting for the system to
start.


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

Would a Win32 guy look at this?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Claudio NatoliDate: 2004-08-26 04:19:37
Subject: Win32 bug fix
Previous:From: pgsqlDate: 2004-08-26 01:33:50
Subject: Re: Contrib -- PostgreSQL shared variables -with swap

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-08-26 02:47:28
Subject: Re: pgsql-server: Update that 8.0 will support MS Win
Previous:From: Neil ConwayDate: 2004-08-25 22:34:13
Subject: Re: pgsql-server: Update that 8.0 will support MS Win

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