【GP集群】基础性运维

greenplum 集群(1master 1standby master 6segments)

 

集群启动/关闭：

gpstart -a ;

gpstop -M fast

只关闭master节点：

pg_ctl stop -s -m fast -D $MASTER_DATA_DIRECTORY或者 pg_ctl stop -s -m fast -D /gpdb/gpbase/gpmaster/gpseg-1

查看standby节点状态(master节点执行)
gpstate -f

 查询segment配置

select dbid,content,role,preferred_role,hostname,port from gp_segment_configuration order by role,dbid;