Re: Several postgres installation on windows possible? - Mailing list pgsql-admin

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 /<path2PostgresADataDir>
>>>
>>> C:\PostgresB>initdb -D /<path2PostgresBDataDir>
>>>
>>> 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