Re: db clustering? - Mailing list pgsql-general

From Bill Moran
Subject Re: db clustering?
Date
Msg-id 20060713064942.ce0271ca.wmoran@collaborativefusion.com
Whole thread Raw
In response to db clustering?  (Peter Murray & Uta Wussing <peteruta@yahoo.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: doesn't recognize "!=-" (not equal to a negative value)
Next
From: "Özgür Tuğrul"
Date:
Subject: stored function - array parameter - how many element in array ?