[Postgres-xc-general] Move from a single-cluster machine to a multi cluster machine.

[Joseph M. <ma...@wi...>]

Okay, I have a postgres-xc “cluster” operating with only one machine in the cluster. What I want to do is load the database from the standard postgres cluster into it, then switch over to make it operational as the postgres server. Then I want to rebuild the original standard postgres machine to be another postgres-xc cluster machine and add it as a second machine to the cluster.
There are still several things about this I have to figure out, but one question I don’t know the answer to is how I bring the two machines into “sync” at the database. Is there some way to add the second machine into the cluster and have it synchronize its database to the first machine in the cluster, or do I have to dump the database, get them running in a two machine cluster with a blank database, and the restore the dump into the two machine cluster?
If the latter, if one machine goes down or something, so that the other is carrying all the load for a bit, how I do bring the two machines back into sync when the failed machine comes back up?
Thank you for your patience and help.
Joe Mays