From peter.egan@senetric.com Thu Jan 4 18:00:16 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EC5A39F938C for ; Thu, 4 Jan 2007 14:00:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 12023-02-2 for ; Thu, 4 Jan 2007 13:59:32 -0400 (AST) X-Greylist: delayed 00:06:39.039523 by SQLgrey-1.7.4 Received: from smtpout10-04.prod.mesa1.secureserver.net (smtpout10-04.prod.mesa1.secureserver.net [64.202.165.238]) by postgresql.org (Postfix) with SMTP id 4ADE49FA440 for ; Thu, 4 Jan 2007 13:59:32 -0400 (AST) Received: (qmail 26195 invoked from network); 4 Jan 2007 17:52:51 -0000 Received: from unknown (75.56.143.197) by smtpout10-04.prod.mesa1.secureserver.net (64.202.165.238) with ESMTP; 04 Jan 2007 17:52:50 -0000 Message-ID: <003501c73029$24632c20$4a01a8c0@EganNotebook> Reply-To: "Peter Egan" From: "Peter Egan" To: Subject: Windows Dependency Issue Date: Thu, 4 Jan 2007 11:52:45 -0600 Organization: Senetric MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0032_01C72FF6.D8EB0650" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200701/25 X-Sequence-Number: 24181 This is a multi-part message in MIME format. ------=_NextPart_000_0032_01C72FF6.D8EB0650 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.=20 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 ------=_NextPart_000_0032_01C72FF6.D8EB0650 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
We have a windows-based server that = uses postgres=20 (8.1) as the db. We use a 'silent install' to install postgres as a = windows=20 service. Our server is then installed as a service with a = dependency on=20 postgres.
 
As seen in other posts, to ensure that = postgres=20 starts up before the server starts, one should use the = pg_ctl command with=20 the '-w' flag. When installed as a service, the '-w' flag isn't = set.=20
 
My question - is there a way to set = this '-w' flag=20 through the silent install process? Or is there another way to = accomplish this=20 without requiring the user to set this after the installation=20 process?
 
Any help would be = appreciated.
 
Thanks,
Pete
 
------=_NextPart_000_0032_01C72FF6.D8EB0650-- From andy.shellam-lists@mailnetwork.co.uk Thu Jan 4 18:37:03 2007 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