Date: Thu, 15 Jun 2006 13:53:33 -0400
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?
Message-Id: <20060615135333.1997750e.wmoran@collaborativefusion.com>
In-Reply-To: <44919625.8040200@drivefaster.net>
References: <OFF8F23C1E.A2D18557-ON4825718E.0027A8DA@pengroup.com.my>
	<44911706.60204@superlativ.dk> <44919625.8040200@drivefaster.net>
Organization: Collaborative Fusion
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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.