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

From: kah_hang_ang(at)toray(dot)com(dot)my
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is it possible to start two instances of postgresql?
Date: 2006-06-15 06:34:51
Message-ID: OF4CFA8733.EF523FED-ON4825718E.0023AF2B@pengroup.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

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


"A. Kretschmer"
<andreas(dot)kretschmer(at)schollg To: pgsql-performance(at)postgresql(dot)org
las.com> cc:
Sent by: Subject: Re: [PERFORM]Is it possible to start two instances of postgresql?
pgsql-performance-owner(at)pos
tgresql.org


06/15/2006 02:07 PM

am 15.06.2006, um 13:58:20 +0800 mailte kah_hang_ang(at)toray(dot)com(dot)my
folgendes:
>
>
>
>
> Hi,
>
> Is it possible to start two instances of postgresql with different port
and
> directory which run simultaneously?

Yes, this is possible, and this is the Debian way for updates.

> If can then will this cause any problem or performance drop down?

Of course, if you have high load in one database ... you have only one
machine.

HTH, 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 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2006-06-15 07:06:52 Re: Is it possible to start two instances of postgresql?
Previous Message Qingqing Zhou 2006-06-15 06:09:43 Re: Test request for Stats collector performance improvement