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

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