Обсуждение: db clustering?

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

Thanks



Yahoo Messenger: peteruta
AIM: retepmurray
AIM: utawussing

Peter Murray & Uta Wussing <peteruta@yahoo.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.

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.