Search Postgresql Archives

Re: installing several PostgreSQL instances on Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux