From: Bill Moran <wmoran@collaborativefusion.com>
To: Dan Harris <fbsd@drivefaster.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Is it possible to start two instances of postgresql?
Date: Thu, 15 Jun 2006 13:53:33 -0400
Message-ID: <20060615135333.1997750e.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <44919625.8040200@drivefaster.net>
References: <OFF8F23C1E.A2D18557-ON4825718E.0027A8DA@pengroup.com.my>
<44911706.60204@superlativ.dk>
<44919625.8040200@drivefaster.net>
In response to Dan Harris <fbsd@drivefaster.net>:
>
> > kah_hang_ang@toray.com.my wrote:
> >
> >> 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..
>
> Just as an anecdote, I am running 30 databases on a single instance and
> it's working quite well. There may be reasons to run multiple
> instances but it seems like tuning them to cooperate for memory would
> pose some problems - e.g. effective_cache_size.
The only reason I can see for doing this is when you need to run two
different versions of PostgreSQL. Which is what I've been forced to
do on one of our servers.
It works, but it's a pain to admin. If you can just put all the databases
in one db cluster (is that terminology still correct?) it'll be much
easier.
--
Bill Moran
Collaborative Fusion Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, fbsd@drivefaster.net
Subject: Re: Is it possible to start two instances of postgresql?
In-Reply-To: <20060615135333.1997750e.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox