pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Umesh Shastry <Umesh.Shastry@aptaracorp.com>
To: Peter Elmers <p.elmers@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Several postgres installation on windows possible?
Date: Fri, 13 Jul 2007 19:19:21 +0530
Message-ID: <81AC07EC7890404E936AF601FFBD39A2@mmkservdev> (raw)
References: <2AA1790B-5D17-4E49-9AB0-C70BB2BB4C2D@gmx.de>
	<6652BF10E38D4DB880F8580F98A82581@mmkservdev>
	<0C584151-555C-4650-9FB6-7D6C839290E4@gmx.de>

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 thread (10+ messages)  latest in thread

Message-ID: <81AC07EC7890404E936AF601FFBD39A2@mmkservdev>
Permalink:  ../81AC07EC7890404E936AF601FFBD39A2@mmkservdev/
Also on:    postgresql.org/message-id/81AC07EC7890404E936AF601FFBD39A2@mmkservdev

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Umesh.Shastry@aptaracorp.com, p.elmers@gmx.de
  Subject: Re: Several postgres installation on windows possible?
  In-Reply-To: <81AC07EC7890404E936AF601FFBD39A2@mmkservdev>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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