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

[Koichi S. <koi...@gm...>]

pgxc_ctl contrib module comes with this capability.   To use this, you
should configure and operate XC cluster with this utility.   The
document will be found in XC documentation.   Online documentation
will be found at http://postgres-xc.sourceforge.net/docs/1_1/

If you'd like to do this manually, the following pgxc_ctl source will
be helpful:

add_coordinatorMaster() in coord_cmd.c: describes how to add coordinator master.
add_datanodeMaster() in datanode_cmd.c: describes how to add datanode master.

Hope they help.

Regards;
---
Koichi Suzuki


2013/11/14 Casper, Stephan <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
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>