Thread: Several postgres installation on windows possible?

Several postgres installation on windows possible?

From
Peter Elmers
Date:
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



Re: Several postgres installation on windows possible?

From
Peter Elmers
Date:
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 -----
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



Re: Several postgres installation on windows possible?

From
Peter Elmers
Date:
Hi Umesh,

I am sorry to say that this method is not possible due to the fact that i want to deploy my application to a system where i do not know whether there is a postgres.
Also, i do not know where it would be, if there is one.

So my postgres installation is a addition to a possible already installed one.

I am pretty sure your way would work, because at *nix, it does. But windows is different... in many ways. Maybe i have to deploy the binary instead of wrapping the installer....

Thanks anyway. You do not need to check, i will try :)


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





Re: Several postgres installation on windows possible?

From
"Umesh Shastry"
Date:
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 -----
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

Re: Several postgres installation on windows possible?

From
"Umesh Shastry"
Date:
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 -----
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 -----
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



Re: Several postgres installation on windows possible?

From
"Anoo Sivadasan Pillai"
Date:

Hi Peter,

It is possible and I have created that in my machine.

            I exact steps to make it are available at Paul’s personal blog.

            If you haven’t still resolved the issue, Just have a look on the following site.

 

            http://people.planetpostgresql.org/paul/index.php?/archives/4-Running-a-Second-Instance-of-PostgreSQL-8.1.4-on-Windows-2003.html

 

Regards,

 

Anoo S Pillai


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Umesh Shastry
Sent: Friday, July 13, 2007 7:19 PM
To: Peter Elmers
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Several postgres installation on windows possible?

 

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

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

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



 

Visit our Website at www.rmesi.co.in

This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information for the intended purpose only. Internet communications are not secure; therefore, RMESI does not accept legal responsibility for the contents of this message. Any views or opinions presented are those of the author only and not of RMESI. If this email has come to you in error, please delete it, along with any attachments. Please note that RMESI may intercept incoming and outgoing email communications.

Freedom of Information Act 2000
This email and any attachments may contain confidential information belonging to RMESI. Where the email and any attachments do contain information of a confidential nature, including without limitation information relating to trade secrets, special terms or prices these shall be deemed for the purpose of the Freedom of Information Act 2000 as information provided in confidence by RMESI and the disclosure of which would be prejudicial to RMESI's commercial interests.

This email has been scanned for viruses by Trend ScanMail.

Re: Several postgres installation on windows possible?

From
Peter Elmers
Date:
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 -----
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 -----
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





Re: Several postgres installation on windows possible?

From
Paul Silveira
Date:
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.


Re: Several postgres installation on windows possible?

From
Peter Elmers
Date:
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


Re: Several postgres installation on windows possible?

From
"plabrh1"
Date:
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