both of the two database are live but use for two different web app.
my company don't want to spend more to buy a new server, so then I think of
to implement both under the same server and one instance..
but then my superior don't want to do that way.
they want to implement two databases in one server but if one of the
database down it will not affect the other, so that's why I need to have
two instances.
"A. Kretschmer"
<andreas.kretschmer@schollg To: pgsql-performance@postgresql.org
las.com> cc:
Sent by: Subject: Re: [PERFORM]Is it possible to start two instances
ofpostgresql?
pgsql-performance-owner@pos
tgresql.org
06/15/2006 03:06 PM
am 15.06.2006, um 14:34:51 +0800 mailte kah_hang_ang@toray.com.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 ===
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend