Re: installing several PostgreSQL instances on Windows

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: installing several PostgreSQL instances on Windows
Date: 2005-10-02 11:35:56
Message-ID: 00ae01c5c745$74959c80$52bffea9@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thanks.

----- Original Message -----
From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>;
<pgsql-general(at)postgresql(dot)org>
Sent: Friday, September 30, 2005 12:58 PM
Subject: RE: [GENERAL] installing several PostgreSQL instances on Windows

> Hello.
>
> Is it possible to install several completely independent
> instances of PostgreSQL on the same Windows machine?
> I'm asking this mostly because I want to have complete
> control over my database, which is not possible if there is
> some other superuser. Therefore I need dedicated Postgres
> server with only one database. But it is possible that a
> client already have a Postgres installed with some other
> database. Is it possible to install a new independent
> PostgreSQL server on the same computer?
>
> Thanks in advance,

Yes, but the installer will only let you put one instance on the machine.
But you can just copy the whole directory of files to a different directory,
and run "pg_ctl register" with a different name there to get a separate
service.
(That is, unless you use different versions. You can put both 8.0 and 8.1 on
the same machine with the installer.)

(Note! This is much safer in 8.1 than in 8.0, because 8.0 has some shared
files in SYSTEM32 that might cause issues if you run multiple different
versions on the same machine)

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-10-02 12:39:51 Re: scoring differences between bitmasks
Previous Message Ben-Nes Yonatan 2005-10-02 10:07:18 Broken pipe