[Postgres-xc-general] Postgres-XC cluster management

[Casper, S. <Ste...@se...>]

Hello,

 

we want to use a postgres-xc cluster with two or more master nodes.

If we start the cluster configuration with a GTM, 2 GTM-proxys, 2
master-coordinators and 2 master-datanodes , we can initialize and use
it.

 

Now we want to add or remove datanodes while the database is still
running. 

If we add a new node, we add that one to the coordinators node list. It
seems the datanode now knows the database schema, but didn't contain any
data. The node is also in write protection mode.

If we remove an existing  datanode (shutdown its kvm and remove it from
the coordinators node list), now the database is not able to execute
queries.

 

We are using Postgres-XC 1.1 beta.

 

So, we would like to know which is the right way to add more new master
nodes to a running cluster and how can we use the cluster after one of
the nodes has crashed? 

 

Best regards,

 

Stephan Casper