[Postgres-xc-general] How to use it?

[Dika Y. <di...@nt...>]

Hi list,

 

I am newer of postgres-xc, now, I am planning to create the postgresql
cluster using this software, and here I have some questions:

 

1)       Can postgres-xc data node and coordinator install in the same
machine, same working directory? How to deploy them?

2)       If I set the coordinator use port 2000 and data node use port
12000, and which my app server will connect to?

3)       Can I install more than one GTM server? And can they work on active
/ standby or active / active mode? How to configure it?

4)       The document descript how to start GTM, coordinator and data node,
but don't descript how to stop it, recovery it. When one of my data node
failed, how to recovery it? And how the coordinator, GTM server..

5)       I saw the architecture of postgre-xc, my understanding is that my
app server will connect to coordinator server, then read / write into it,
right?

6)       Does it need to deploy a SAN/NAS/NFS file system for the data node
servers or coordinator servers? Or the data keep a copy in each data node
server or coordinator server?

7)       How many data node server or coordinator server does it support?
How to add a new data node server or coordinator server into the current
postgres-xc system?

 

Is there any configuration sample? Where can find it?

 

Thanks.

 

Best wishes,

 

Dika.Ye