Re: db clustering?

On Wed, 2006-07-12 at 15:22, Peter Murray & Uta Wussing wrote:
> I have some postgres cluster questions:
>
> I would like to have the ability to dynamically re-size a cluster of
> Postgres DB instances.
>
>
> 0. Can I create a Postgres cluster?
> - more than one instance of Postgres running on more than 1 cpu acting
> as a single instance of postgres to process work. i.e. 1 pg/cpu
>
> 1. start postgres on another box
> 2. have it added to the cluster and have it start processing work for
> it.
> 3. have the instance stop processing work and remove the instance from
> the cluster

There is no such software currently existent for postgresql that I know
of. There are pieces of software that, with the watchful eye of a
competent dba can do most of what you ask, but there's no "push a button
take a banana" interface / implementation.