pgxc_ctl commands
創建
add gtm master name host port dir
add gtm slave name host port dir
add gtm_proxy name host port dir
add coordinator master name host port pooler dir extraServerConf extraPgHbaConf
add coordinator slave name host port pooler dir archDir
add datanode master name host port pooler dir xlogdir extraServerConf extraPgHbaConf
add datanode slave name host port pooler dir xlogdir archDir初始化
init [force] all
init [force] nodename ...
init [force] gtm [ master | slave | all ]
init [force] gtm_proxy [ all | nodename ... ]
init [force] coordinator nodename ...
init [force] coordinator [ master | slave ] [ all | nodename ... ]
init [force] datanode nodename ...
init [force] datanode [ master | slave ] [ all | nodename ... ]初始化過程中，每個組件的工作目錄如果不存在，將會被創建。如果指定[force]，將會工作目錄下的所有內容將會被移除。不使用[force]，則不會清除已經存在目錄下的內容。
kill
kill all
kill nodename ...
kill gtm [ master | slave | all ]
kill gtm_proxy [ all | nodename ... ]
kill coordinator nodename ...
kill coordinator [ master | slave ] [ all | nodename ... ]
kill datanode nodename ...
kill datanode [ master | slave ] [ all | nodename ... ]如果被指定kill的節點有master和slave，則兩個節點將會被關閉。
日誌
log [ variable | var ] *varname*
log [ message | msg ] *message_body*
Prints the specified contents to the log file. Variable or var option writes specified variable name and its value. Message or msg option writes specified message.
monitor all
monitor nodename ...
monitor gtm [ master | slave | all ]
monitor gtm_proxy [ all | nodename ... ]
monitor coordinator nodename ...
monitor coordinator [ master | slave ] [ all | nodename ... ]
monitor datanode nodename ...
monitor datanode [ master | slave ] [ all | nodename ... ]監控指定節點是否行動
reconnect gtm_proxy [ all | nodename ... ]當failover到slave GTM之後，需要執行重新連接指定的節點的操作。
刪除節點
remove gtm master [ clean ]
remove gtm slave [ clean ]
remove gtm_proxy nodename [ clean ]
remove coordinator [ master| slave ] nodename [ clean ]
remove datanode [ master| slave ] nodename [ clean ]開始節點
start all
start nodename ...
start gtm [ master | slave | all ]
start gtm_proxy [ all | nodename ... ]
start coordinator nodename ...
start coordinator [ master | slave ] [ all | nodename ... ]
start datanode nodename ...
start datanode [ master | slave ] [ all | nodename ... ]暫停節點
stop [ -m smart | fast | immediate ] all
stop gtm [ master | slave | all ]
stop gtm_proxy [ all | nodename ... ]
stop [ -m smart | fast | immediate ] coordinator nodename ...
stop [ -m smart | fast | immediate ] coordinator [ master | slave ] [ all | nodename ... ]
stop [ -m smart | fast | immediate ] datanode nodename ...
stop [ -m smart | fast | immediate ] datanode [ master | slave ] [ all | nodename ... ]取消GTM中的註冊節點
當節點崩潰啟動新節點時，可能需要註銷在GTM中註冊的節點。
unregister unregister_option ...
# unregister_option有以下參數：
-n name: #指定需要註冊的節點
-Z { gtm | gtm_proxy | gtm_proxy_postmaster | coordinator | datanode } # 指定節點類別以下文章點擊率最高
Loading…