[Postgres-xc-general] Setting up multiple coordinators

[Aaron J. <aja...@re...>]

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.

Aaron