Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9292B9FB669 for ; Tue, 17 Jul 2007 21:43:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 82636-03 for ; Tue, 17 Jul 2007 21:43:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.229]) by postgresql.org (Postfix) with ESMTP id CEFA89FB667 for ; Tue, 17 Jul 2007 21:43:38 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 37so16619wra for ; Tue, 17 Jul 2007 17:43:37 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:cc:references:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:in-reply-to:x-mimeole; b=ELZzj3F3HLHMxGNBjNuRIKd1vZ963L9lkw57O4VnitbnG+1NXvxivNAmXkguYr6GTXfu4ojjlx9j7qKnZuTwMIqldi+3h7HUwZDVNI10Xqx9tsqTina2GiPeFN1nNMWAa0Hj549ZBKzcCU85bt4BYRkAVTXpMwTC+tBsxXQb4hg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:cc:references:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:in-reply-to:x-mimeole; b=PQXSURsvt1sHFMIC4N9UN+qcqQHubNJTmQoH/e72JFVsbfUAPtZhtmOh/3jHvnDR6fjZszW5YNRUuqEF+6cG40a6nf+hmWciT73uJDX/zTJvv7Yw/1YobuCU54C4/WBKLEeq2sx6ok5GbbISW6JOCXUGH8qNAmdioH28zRckct8= Received: by 10.90.115.9 with SMTP id n9mr1038293agc.1184719417560; Tue, 17 Jul 2007 17:43:37 -0700 (PDT) Received: from plab034 ( [75.182.85.94]) by mx.google.com with ESMTPS id 34sm131934agc.2007.07.17.17.43.34 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 17 Jul 2007 17:43:35 -0700 (PDT) From: "plabrh1" To: "'Peter Elmers'" Cc: References: <2AA1790B-5D17-4E49-9AB0-C70BB2BB4C2D@gmx.de> <6652BF10E38D4DB880F8580F98A82581@mmkservdev> <0C584151-555C-4650-9FB6-7D6C839290E4@gmx.de> <81AC07EC7890404E936AF601FFBD39A2@mmkservdev> <873122BD-9EA0-4664-80CD-C9F74E9DB858@gmx.de> <11655068.post@talk.nabble.com> Subject: Re: Several postgres installation on windows possible? Date: Tue, 17 Jul 2007 20:43:33 -0400 Message-ID: <000001c7c8d4$ac2d4b60$ea01a8c0@plab034> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcfItD+YeY1kLiauQMeHyDAyi2W0lgAIBlEg In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/195 X-Sequence-Number: 26176 Great... Good luck... Just an additional note, I've chosen a naming convention with the folders for all of my PostgreSQL installs that matches the ports that they are running on. For instance, I have a pgdata folder that has a 5432 and a 5433 folder in it. I then copy the binaries into those folders, execute the commands necessary to make windows aware of the installs and away you go... Paul -----Original Message----- From: Peter Elmers [mailto:p.elmers@gmx.de] Sent: Tuesday, July 17, 2007 4:51 PM To: Paul Silveira Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Several postgres installation on windows possible? Hi Paul, i did not received a eMail with the answer and the Link to your Blog from the postgres list. But a link within this eMail lead me to the correct answer and link. Your blog entry looks pretty suitable. Especially the "postgres register" could be a nice way to deploy just the binaries and resolve some of my biggest issues with the installer(registry entries). Tomorrow, i will try and report. Thanks! Peter Am 17.07.2007 um 20:16 schrieb Paul Silveira: > > Hello, > > What if you just rolled your own installer so that you would have > control > over everything. > > You could follow my blog (that was referenced earlier in this > thread) to > some degree. > > The first think that I would do is to get an install just the way > you want > it on a DEV machine. Then I would package that install and deploy > that > using .BAT files that would check to see if the NT User existed, > registering > the service, and all of the other things that would need to be done. > Basically the second half of my blogged article. > > Would that work? > > Paul > > > > Peter Elmers wrote: >> >> Hi! >> >> I am still working on this problem. With the installer of postgres, >> it is not possible for me to install a second postgresql(maybe i just >> try it in the wrong way?)! >> With the binary, there are some showstoppers for me (executing as >> postgres-user and adding a service with activated panda-VS and so >> on). >> >> Regards, >> >> >> Peter >> >> Am 13.07.2007 um 15:49 schrieb Umesh Shastry: >> >>> Hi Peter, >>> >>> Say you have installed PostgreSQL in C:/PostgresA directory... make >>> a copy of this folder as C:/PostgreSQLB... edit the conf file say >>> postgres.conf(this should be in /data directory) file of second >>> server in C:/PostgreSQLB & locate the port & change it to 5433... >>> then you can start both servers with >>> >>> C:\PostgresA>initdb -D / >>> >>> C:\PostgresB>initdb -D / >>> >>> Pls note that I haven't checked this thing..if you want me to check >>> then gimme 1 day..I would check it & let you know.. >>> >>> Thanks, >>> Umesh >>> ----- Original Message ----- >>> From: Peter Elmers >>> To: Umesh Shastry >>> Cc: pgsql-admin@postgresql.org >>> Sent: Friday, July 13, 2007 7:04 PM >>> Subject: Re: [ADMIN] Several postgres installation on windows >>> possible? >>> >>> Hi Umesh, >>> >>> Thanks for the fast reply, but how can i install the second, >>> third,.... postgres? As mentioned, the installer comes up with a >>> simple change dialogue. >>> >>> >>> Peter >>> >>> Am 13.07.2007 um 15:24 schrieb Umesh Shastry: >>> >>>> Hi Peter, >>>> >>>> I think it is possible you can run multiple servers on a single >>>> machine, provided on different port & data directory. >>>> >>>> Thanks, >>>> Umesh >>>> ----- Original Message ----- >>>> From: Peter Elmers >>>> To: pgsql-admin@postgresql.org >>>> Sent: Friday, July 13, 2007 6:52 PM >>>> Subject: [ADMIN] Several postgres installation on windows possible? >>>> >>>> Hi Guys, >>>> >>>> I like to deploy a application based on postgres and i am pretty >>>> unsure whether it is possible to have several postgres installation >>>> on windows running in parallel. >>>> The normal installer comes up with a "change dialogue" if i try to >>>> install a second time or postgres is already installed on the >>>> target >>>> machine and i run my setup with the postgres installer included. >>>> >>>> Thanks for reading and answering, >>>> >>>> >>>> Peter >>>> >>>> >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 3: Have you checked our extensive FAQ? >>>> >>>> http://www.postgresql.org/docs/faq >>>> >>>> >>> >>> >> >> >> > > -- > View this message in context: http://www.nabble.com/Several- > postgres-installation-on-windows-possible--tf4074458.html#a11655068 > Sent from the PostgreSQL - admin mailing list archive at Nabble.com. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster