TDSQL PostgreSQL 版 （原 TBase）集群管理必会命令

启动集群

通过pgxc_ctl工具的start all命令来启动集群

进入pgxc_ctl工具

[tbase@tbase159 ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash --home /opt/data/tbase/pgxc_ctl --configuration /opt/data/tbase/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /opt/data/tbase/pgxc_ctl
PGXC

启动集群

通过pgxc_ctl工具的start all命令来启动集群

[tbase@tbase159 ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash --home /opt/data/tbase/pgxc_ctl --configuration /opt/data/tbase/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /opt/data/tbase/pgxc_ctl
PGXC start all   --注意是在PGXC 后面输入 start all然后回车

查看集群状态

进入pgxc_ctl工具

[tbase@tbase159 ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash --home /opt/data/tbase/pgxc_ctl --configuration /opt/data/tbase/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /opt/data/tbase/pgxc_ctl
PGXC

查看集群状态

通过pgxc_ctl工具的monitor all命令来查看集群状态

[tbase@tbase159 ~]$ pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /opt/data/tbase/pgxc_ctl/pgxc_ctl_bash --home /opt/data/tbase/pgxc_ctl --configuration /opt/data/tbase/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
   ******** PGXC_CTL START ***************

Current directory: /opt/data/tbase/pgxc_ctl
PGXC
PGXC monitor all   -- 注意是在PGXC 后面输入 monitor all 然后回车
Running: gtm master
Not running: gtm slave
Running: coordinator master cn001
Running: coordinator master cn002
Running: datanode master dn001
Running: datanode slave dn001
Running: datanode master dn002
Running: datanode slave dn002

停止集群

通过pgxc_ctl工具的stop all命令来停止集群，stop all 后面可以加上参数 -m fast或者是-m immediate来决定如何停止各个节点。

pgxc_ctl stop all -m fast