Skip site navigation (1) Skip section navigation (2)

Re: Is it possible to start two instances of postgresql?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is it possible to start two instances of postgresql?
Date: 2006-06-15 07:06:52
Message-ID: 20060615070652.GE22034@webserv.wug-glas.de (view raw or flat)
Thread:
Lists: pgsql-performance
am  15.06.2006, um 14:34:51 +0800 mailte kah_hang_ang(at)toray(dot)com(dot)my folgendes:
> 
> 
> 
> 
> so what is the best way to implement two databases in one machine?
> implement with two postgresql instances with separate directory or
> implement under one instance?

What do you want to do?
Do you need 2 separate pg-versions? Or do you need, for instance, a
live-db and a test-db? 


> if I implement two database in one instance, if one of the database crash
> will it affect the other?

Yes, but on the other side, if you have 2 instances on the same machine
and this machine chrash, then you lost all.
What do you want to do? Perhaps, you need slony? (replication solution)



Btw.: please, no silly fullquote.


Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

In response to

pgsql-performance by date

Next:From: kah_hang_angDate: 2006-06-15 07:24:35
Subject: Re: Is it possible to start two instances of postgresql?
Previous:From: kah_hang_angDate: 2006-06-15 06:34:51
Subject: Re: Is it possible to start two instances of postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group