pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Several postgres installation on windows possible?
10+ messages / 5 participants
[nested] [flat]

* Several postgres installation on windows possible?
@ 2007-07-13 13:22  Peter Elmers <p.elmers@gmx.de>
  0 siblings, 1 reply; 10+ messages in thread

From: Peter Elmers @ 2007-07-13 13:22 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-13 13:24  Umesh Shastry <Umesh.Shastry@aptaracorp.com>
  parent: Peter Elmers <p.elmers@gmx.de>
  0 siblings, 1 reply; 10+ messages in thread

From: Umesh Shastry @ 2007-07-13 13:24 UTC (permalink / raw)
  To: pgsql-admin; Peter Elmers <p.elmers@gmx.de>

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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-13 13:34  Peter Elmers <p.elmers@gmx.de>
  parent: Umesh Shastry <Umesh.Shastry@aptaracorp.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Peter Elmers @ 2007-07-13 13:34 UTC (permalink / raw)
  To: Umesh Shastry <Umesh.Shastry@aptaracorp.com>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-13 13:49  Umesh Shastry <Umesh.Shastry@aptaracorp.com>
  parent: Peter Elmers <p.elmers@gmx.de>
  0 siblings, 2 replies; 10+ messages in thread

From: Umesh Shastry @ 2007-07-13 13:49 UTC (permalink / raw)
  To: Peter Elmers <p.elmers@gmx.de>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-13 14:12  Peter Elmers <p.elmers@gmx.de>
  parent: Umesh Shastry <Umesh.Shastry@aptaracorp.com>
  1 sibling, 0 replies; 10+ messages in thread

From: Peter Elmers @ 2007-07-13 14:12 UTC (permalink / raw)
  To: Umesh Shastry <Umesh.Shastry@aptaracorp.com>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-16 04:43  Anoo Sivadasan Pillai <aspillai@in.rm.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Anoo Sivadasan Pillai @ 2007-07-16 04:43 UTC (permalink / raw)
  To: Peter Elmers <p.elmers@gmx.de>; +Cc: pgsql-admin

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

	From: Peter Elmers <mailto:p.elmers@gmx.de>  

	To: Umesh Shastry <mailto:Umesh.Shastry@aptaracorp.com>  

	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 <mailto:p.elmers@gmx.de> 

		To: pgsql-admin@postgresql.org
<mailto: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
<http://www.postgresql.org/docs/faq; 

	
	
	

	 
Visit our Website at http://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.

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-17 07:25  Peter Elmers <p.elmers@gmx.de>
  parent: Umesh Shastry <Umesh.Shastry@aptaracorp.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Peter Elmers @ 2007-07-17 07:25 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org, Umesh Shastry <Umesh.Shastry@aptaracorp.com>

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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-17 18:16  Paul Silveira <plabrh1@gmail.com>
  parent: Peter Elmers <p.elmers@gmx.de>
  0 siblings, 1 reply; 10+ messages in thread

From: Paul Silveira @ 2007-07-17 18:16 UTC (permalink / raw)
  To: pgsql-admin


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.




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-17 20:51  Peter Elmers <p.elmers@gmx.de>
  parent: Paul Silveira <plabrh1@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Peter Elmers @ 2007-07-17 20:51 UTC (permalink / raw)
  To: Paul Silveira <plabrh1@gmail.com>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Several postgres installation on windows possible?
@ 2007-07-18 00:43  plabrh1 <plabrh1@gmail.com>
  parent: Peter Elmers <p.elmers@gmx.de>
  0 siblings, 0 replies; 10+ messages in thread

From: plabrh1 @ 2007-07-18 00:43 UTC (permalink / raw)
  To: 'Peter Elmers' <p.elmers@gmx.de>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2007-07-18 00:43 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-13 13:22 Several postgres installation on windows possible? Peter Elmers <p.elmers@gmx.de>
2007-07-13 13:24 ` Umesh Shastry <Umesh.Shastry@aptaracorp.com>
2007-07-13 13:34   ` Peter Elmers <p.elmers@gmx.de>
2007-07-13 13:49     ` Umesh Shastry <Umesh.Shastry@aptaracorp.com>
2007-07-13 14:12       ` Peter Elmers <p.elmers@gmx.de>
2007-07-17 07:25       ` Peter Elmers <p.elmers@gmx.de>
2007-07-17 18:16         ` Paul Silveira <plabrh1@gmail.com>
2007-07-17 20:51           ` Peter Elmers <p.elmers@gmx.de>
2007-07-18 00:43             ` plabrh1 <plabrh1@gmail.com>
2007-07-16 04:43 Re: Several postgres installation on windows possible? Anoo Sivadasan Pillai <aspillai@in.rm.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox