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

[Michael P. <mic...@gm...>]

Hi,

>
> > 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……
>
> gtm_ctl and pg_ctl utilities can stop these features, like PostgreSQL.
> Michael: Could you provide the information how to stop them?
>
>
As written below we designed two utilities to start, restart or stop
Postgres-XC components:
- gtm_ctl, used to interact with GTM or GTM-proxy
- pg_ctl, directly inspired from the existing application in PostgreSQL. It
has been extended so as to be able to interact with Postgres-XC Coordinator
and Datanode.

To be more precise, for pg_ctl:
1) This permits to start a Datanode or a Cooordinator with the data folder
specified and some customized options.
pg_ctl start ­-S coordinator ­-D /data/folder -o '-p $port_number +
additional options'
pg_ctl start ­-S datanode ­-D /data/folder -o '-p $port_number + additional
options'

2) This permits to stop a Coordinator or a Datanode with the data folder
specified.
pg_ctl stop ­-S coordinator ­-D /data/folder
pg_ctl stop ­-S Datanode ­-D /data/folder
3) This permits to restart a Coordinator or a Datanode with the data_folder
specified and relaunch it with the new options specidied in the string of
'-o'.
pg_ctl restart ­-S coordinator ­-D /data/folder -o '-p $port_number +
additional options'
pg_ctl restart ­-S Datanode ­-D /data/folder -o '-p $port_number +
additional options'


gtm_ctl permits to do the same with GTM and GTM-proxy processes.
use -S option to specify if the data folder chosen is of the type 'GTM' or
'GTM-proxy'
As before you can start/stop/restart processes such types of commands:
gtm_ctl start[stop/restart] ­-S gtm[gtm-proxy] ­-D /data/folder -o 'new
options'

You can refer to this document to find all the details of those
applications:
https://sourceforge.net/projects/postgres-xc/files/Version_0.9.2/PG-XC_ReferenceManual_v0_9_2.pdf/download


Thanks,

-- 
Michael Paquier