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
|
