Re: [Postgres-xc-general] Cluster avaibility

[Michael P. <mic...@gm...>]

On Wed, Jan 4, 2012 at 10:47 PM, Magorn <ma...@gm...> wrote:

> Hi,
>
> I have question about Postgres-XC. I have test it with 2 node, i create
> "distribute by replication" table. I do some insert.
> I do SELECT and i see all my records. That's fine :)
>
> Next i shutdown one datanode, and i do SELECT that it fail with error :
> ERROR:  Failed to get pooled connections .
>
> Is it normal ? And if is it, when cluster have a lot of node, how stop
> some node for changer server for example without bloc all the cluser ?
>
> Perhaps i miss something about feature of postgres-xc.
>
As said before by Ashutosh, you are missing nothing. For the time being XC
is made to run with a constant number of Coordinators and Datanodes.
There are already basics to have support for dynamic addition and deletion
of nodes, and we are working on strengthening the cluster setup to maintain
global consistency. However, such features as the one you mentionned is
something different that we may target after 1.0 is out.

In case you are also interested in the feature regarding node selection of
a replicated table that fails, you could also give a try and propose a
feature spec to write a patch.
-- 
Thanks,

Michael Paquier
http://michael.otacoo.com