Re: [Postgres-xc-general] postgres-xc 0.9.5: Do not have a GTM snapshot available / Failed to get pooled connection

[David H. <dav...@me...>]

Op 11-07-11 11:22, David Hartveld schreef:
> Op 11-07-11 07:17, Abbas Butt schreef:
>> I noticed that you have given 2 as pgxc_node_id in both the files you
>> have attached. Please make sure you have given different numbers to all
>> the 4 nodes.
>
> I need a little clarification for this point. In the installation manual
> is suggested that pgxc_node_id is the index into the coordinator_hosts
> and coordinator_ports arrays, as well as into datanode_hosts /
> datanode_ports. But you suggest i assign unique numbers to each node. If
> it should be the latter, this could be improved in the installation manual.

Following up on my own post, coordinators and data nodes each have their 
own sequence of index numbers, all starting at 1, up to n (the number of 
coordinators and data nodes respectively).

After pointing the correct indices to the correct hosts (in the 
coordinator_hosts and data_node_hosts arrays), I've gotten the 
distributed cluster to create a database on one node, and to connect to 
it to the other. I'm now going to try to run a more extensive test, and 
will let you know the results if anything interesting happens ;-)

Thank you all for your help,
David Hartveld