greenplum不通过gpstart命令启动

总共三台机器，greenplum集群SEGMENT配置情况如下

[gpadmin1@hadoop1 ~]$ gpstate -c
20101027:15:43:23:gpstate:hadoop1:gpadmin1-[INFO]:-Starting gpstate with args: -c
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.0.1.0 build 1'
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-Obtaining Segment details from master...
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:--------------------------------------------------------------
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:--Current GPDB mirror list and status
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:--Type = Group
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:--------------------------------------------------------------
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Status                             Data State     Primary   Datadir                           Port    Mirror    Datadir                           Port
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Mirror Active, Primary Available   Synchronized   hadoop1   /home/gpadmin1/gp4datap1/aligp0   30000   hadoop2   /home/gpadmin1/gp4datam1/aligp0   40000
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Mirror Active, Primary Available   Synchronized   hadoop1   /home/gpadmin1/gp4datap2/aligp1   30001   hadoop2   /home/gpadmin1/gp4datam2/aligp1   40001
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Mirror Active, Primary Available   Synchronized   hadoop2   /home/gpadmin1/gp4datap1/aligp2   30000   hadoop3   /home/gpadmin1/gp4datam1/aligp2   40000
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Mirror Active, Primary Available   Synchronized   hadoop2   /home/gpadmin1/gp4datap2/aligp3   30001   hadoop3   /home/gpadmin1/gp4datam2/aligp3   40001
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Primary Active, Mirror Available   Synchronized   hadoop3   /home/gpadmin1/gp4datap1/aligp4   30000   hadoop1   /home/gpadmin1/gp4datam1/aligp4   40000
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:-   Primary Active, Mirror Available   Synchronized   hadoop3   /home/gpadmin1/gp4datap2/aligp5   30001   hadoop1   /home/gpadmin1/gp4datam2/aligp5   40001
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[INFO]:--------------------------------------------------------------
20101027:15:43:24:gpstate:hadoop1:gpadmin1-[WARNING]:-4 segment(s) configured as mirror(s) are acting as primaries

 

MASTER节点在HADOOP1上，STANDBY在HADOOP2上。

 

在HADOOP1上执行如下语句

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap1/aligp0 -l /home/gpadmin1/gp4datap1/aligp0/pg_log/startup.log -o '-i -p 30000  --silent-mode=true -M quiescent -b 2 -C 0 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap2/aligp1 -l /home/gpadmin1/gp4datap2/aligp1/pg_log/startup.log -o '-i -p 30001  --silent-mode=true -M quiescent -b 3 -C 1 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam1/aligp4 -l /home/gpadmin1/gp4datam1/aligp4/pg_log/startup.log -o '-i -p 40000  --silent-mode=true -M quiescent -b 12 -C 4 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam2/aligp5 -l /home/gpadmin1/gp4datam2/aligp5/pg_log/startup.log -o '-i -p 40001  --silent-mode=true -M quiescent -b 13 -C 5 -z 6' start


$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30000 -i /home/gpadmin1/gp4datap1/aligp0/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30001 -i /home/gpadmin1/gp4datap2/aligp1/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40000 -i /home/gpadmin1/gp4datam1/aligp4/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40001 -i /home/gpadmin1/gp4datam2/aligp5/gp_pmtransition_args

在 HADOOP2上执行如下语句
$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap1/aligp2 -l /home/gpadmin1/gp4datap1/aligp2/pg_log/startup.log -o '-i -p 30000  --silent-mode=true -M quiescent -b 4 -C 2 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap2/aligp3 -l /home/gpadmin1/gp4datap2/aligp3/pg_log/startup.log -o '-i -p 30001  --silent-mode=true -M quiescent -b 5 -C 3 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam1/aligp0 -l /home/gpadmin1/gp4datam1/aligp0/pg_log/startup.log -o '-i -p 40000  --silent-mode=true -M quiescent -b 8 -C 0 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam2/aligp1 -l /home/gpadmin1/gp4datam2/aligp1/pg_log/startup.log -o '-i -p 40001  --silent-mode=true -M quiescent -b 9 -C 1 -z 6' start

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30000 -i /home/gpadmin1/gp4datap1/aligp2/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30001 -i /home/gpadmin1/gp4datap2/aligp3/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40000 -i /home/gpadmin1/gp4datam1/aligp0/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40001 -i /home/gpadmin1/gp4datam2/aligp1/gp_pmtransition_args

在 HADOOP3上执行如下语句
$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap1/aligp4 -l /home/gpadmin1/gp4datap1/aligp4/pg_log/startup.log -o '-i -p 30000  --silent-mode=true -M quiescent -b 6 -C 4 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datap2/aligp5 -l /home/gpadmin1/gp4datap2/aligp5/pg_log/startup.log -o '-i -p 30001  --silent-mode=true -M quiescent -b 7 -C 5 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam1/aligp2 -l /home/gpadmin1/gp4datam1/aligp2/pg_log/startup.log -o '-i -p 40000  --silent-mode=true -M quiescent -b 10 -C 2 -z 6' start

$GPHOME/bin/pg_ctl -D /home/gpadmin1/gp4datam2/aligp3 -l /home/gpadmin1/gp4datam2/aligp3/pg_log/startup.log -o '-i -p 40001  --silent-mode=true -M quiescent -b 11 -C 3 -z 6' start

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30000 -i /home/gpadmin1/gp4datap1/aligp4/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 30001 -i /home/gpadmin1/gp4datap2/aligp5/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40000 -i /home/gpadmin1/gp4datam1/aligp2/gp_pmtransition_args

$GPHOME/bin/gp_primarymirror -h 127.0.0.1 -p 40001 -i /home/gpadmin1/gp4datam2/aligp3/gp_pmtransition_args

在 HADOOP1上执行如下语句
$GPHOME/bin/pg_ctl -w -D /home/gpadmin1/gp4master/aligp-1 -l /home/gpadmin1/gp4master/aligp-1/pg_log/startup.log -o "   -E  -i -M master -p 2345 -b 1 -x 0 -C -1 -z 6 --silent-mode=true " start

waiting for server to start....

 done
server started

[gpadmin1@hadoop4 gpdb_p1]$ psql
NOTICE:  Master mirroring synchronizing
psql (8.2.14)
Type "help" for help.

aligputf8=#

 

只可惜gp_primarymirror这个命令在$GPHOME/bin目录下虽然有，可是没找到相关帮助信息。

我尝试过，不执行这个命令所有的INSTANCE也可以启动起来，不过不能正常工作，就像下面这样

[gpadmin1@hadoop1 ~]$ psql -c 'select * from gp_segment_configuration;'
NOTICE:  Master mirroring synchronizing
WARNING:  Greenplum Database detected segment failure(s), system is reconnected
WARNING:  Greenplum Database detected segment failure(s), system is reconnected
WARNING:  Greenplum Database detected segment failure(s), system is reconnected
WARNING:  Greenplum Database detected segment failure(s), system is reconnected
psql: FATAL:  DTM initialization: failure during startup/recovery, retry failed, check segment status (cdbtm.c:1326)