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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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