Re: [Postgres-xc-general] Setting up multiple coordinators

[Ashutosh B. <ash...@en...>]

On Thu, Apr 24, 2014 at 12:49 AM, Aaron Jackson <aja...@re...>wrote:

>   I've read through several pieces of documentation but couldn't find an
> answer, short of experimentation.  I'm really unclear about how
> coordinators are "managed" when they are in a cluster.  From what I can
> tell, it looks like each node in a cluster must be individually setup ...
> for example.
>
>  I have three nodes, A, B & C.
>
>  - A is my GTM instance.
> - B & C newly created data nodes and coordinators - nothing in them
>
>  Now let's say I want to make B & C aware of each other at the
> coordinator level.  So on server B, I connect to the coordinator and issue
> the following:
>
>  CREATE NODE coord_2 WITH (TYPE = 'coordinator', PORT = 5432, HOST =
> 'B');
> select pgxc_pool_reload();
> select * from pg_catalog.pgxc_node;
>
>  And as expected, I now have two entries in pgxc_node.  I hop over to
> machine C ...
>
>  select * from pg_catalog.pgxc_node;
>
>  This returns only a row for itself.  Okay, so I reload the pool and
> still one row.  This implies that adding a coordinator node only affects
> the coordinator where it was run on.  So, I must go to all machines in my
> cluster and tell them that there is a new coordinator.
>
>  I just want to make sure I'm not missing something obvious.  If this is
> the way it's designed to work, then that's fine.
>
>
You are right. We have to "introduce" each node (not just coordinator but
datanode as well) to all (other, if applicable), coordinators.


>  Aaron
>
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company