Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 89EEC9FA4B5 for ; Thu, 4 Jan 2007 14:37:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 42773-09 for ; Thu, 4 Jan 2007 14:36:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 922949F95CB for ; Thu, 4 Jan 2007 14:36:52 -0400 (AST) Received: from user-514c037d.l1.c5.dsl.pol.co.uk ([81.76.3.125]:3623 helo=[192.168.1.2]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H2XSP-0004RU-AG; Thu, 04 Jan 2007 18:36:53 +0000 Message-ID: <459D497C.3080506@mailnetwork.co.uk> Date: Thu, 04 Jan 2007 18:37:48 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Peter Egan CC: pgsql-admin@postgresql.org Subject: Re: Windows Dependency Issue References: <003501c73029$24632c20$4a01a8c0@EganNotebook> In-Reply-To: <003501c73029$24632c20$4a01a8c0@EganNotebook> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200701/26 X-Sequence-Number: 24182 Hello Pete, There is certainly a Windows command you can run that will alter the command used to start a service - it's "sc" (which can also be used to start/stop a service programmatically.) The command syntax to modify the EXE path is: sc config binpath= "" (eg.) sc config "PostgreSQL Database Server " binpath= "C:\Program Files\PostgreSQL\bin\" If it's successful, you'll get the message: "[SC] ChangeServiceConfig SUCCESS" Also note there's a space between "binpath=" and the EXE name - that took me a while to figure out! Hope this can be of use. Andy. Peter Egan wrote: > Hello, > > We have a windows-based server that uses postgres (8.1) as the db. We > use a 'silent install' to install postgres as a windows service. Our > server is then installed as a service with a dependency on postgres. > > As seen in other posts, to ensure that postgres starts up before the > server starts, one should use the pg_ctl command with the '-w' > flag. When installed as a service, the '-w' flag isn't set. > > My question - is there a way to set this '-w' flag through the silent > install process? Or is there another way to accomplish this without > requiring the user to set this after the installation process? > > Any help would be appreciated. > > Thanks, > Pete > > !DSPAM:37,459d40d631947254553576! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834