Re: db clustering?

Peter Murray & Uta Wussing <peteruta(at)yahoo(dot)com> 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

Have a look at pgCluster and/or pgPool.

--
Bill Moran

ZOE: Preacher, don't the Bible have some pretty specific things to say about
killing?
BOOK: Quite specific. It is, however, somewhat fuzzier on the subject of
kneecaps.