Thread: 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

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

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

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.

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

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