EMCGreenplum安裝手冊(cè)-redhat

1、3.操作系統(tǒng)安裝服務(wù)器啟動(dòng)時(shí)根據(jù)提示使用ctrl+f鍵進(jìn)入Raid卡設(shè)置，使用strip size 128KB, 啟用讀緩存, 啟用寫(xiě)緩存, 將6塊SAS劃為一個(gè)磁盤(pán)組。服務(wù)器重啟后進(jìn)入操作系統(tǒng)安裝：3.1.分區(qū)依據(jù)：/bootext3100MBSwapswap內(nèi)存大小/ext3100GB不作處理不作處理剩余空間*注：剩余空間約1.3TB不處理，用于操作系統(tǒng)安裝后使用xfs格式化。系統(tǒng)安裝完畢使用xfs格式化如下：mkfs.xfs /dev/sda43.2.文件包依據(jù)：不要安裝防火墻, selinux, LVM不要安裝辦公工具，例如office，瀏覽器，游戲，音視頻工具必須安裝開(kāi)發(fā)工具，例如g

2、libc4.操作系統(tǒng)配置修改內(nèi)核調(diào)度/boot/grub/menu.lst文件kernal添加elevator=deadline如下：rootlocalhost # vi /boot/grub/menu.lstdefault=0timeout=5hiddenmenutitle Red Hat Enterprise Linux Server (2.6.18-308.el5) root (hd0,0) kernel /vmlinuz-2.6.18-308.el5 ro root=LABEL=/ rhgb quiet elevator=deadline修改/etc/rc.d/rc.local文件中所

3、有磁盤(pán)預(yù)讀為16384 （）NO如下：rootlocalhost # blockdev -setra 16384 /dev/sd*修改/etc/sysctl.conf添加如下內(nèi)容：net.ipv4.ip_forward = 0net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.sem = 250 64000 100 2048ke

4、rnel.shmmax = 5000000000kernel.shmmni = 40960kernel.shmall = 40000000000net.ipv4.tcp_tw_recycle=1net.ipv4.tcp_max_syn_backlog=4096dev_max_backlog=10000vm.overcommit_memory=2net.ipv4.conf.all.arp_filter = 1修改/etc/security/limits.conf添加如下內(nèi)容：* soft nofile 1048576* hard nofile 1048576* soft nproc 104857

5、6* hard nproc 1048576修改/etc/sysconfig/network 文件中hostname如下：rootlocalhost # vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=crsz6sbidw01修改所有服務(wù)器/etc/hosts建立集群通信（NO，與此不同）rootlocalhost # vi /etc/hosts localhost7 mdw-1 mdw crsz6sbidw01 sdw1-1 sdw1 mdw-2 sdw1-2 mdw-3 sdw1-3 mdw-4 sdw1-4

6、8 smdw-1 smdw crsz6sbidw02 sdw2-1 sdw2 smdw-2 sdw2-2 smdw-3 sdw2-3 smdw-4 sdw2-4修改/data掛載xfs設(shè)備（NO）rootlocalhost # vi /etc/fstabLABEL=/ / ext3 defaults 1 1LABEL=/boot1 /boot ext3 defaults 1 2tmpfs /dev/shm tmpfs defaults 0 0devpts /dev/pts devpts gid=5,mode=620 0 0sysfs /sys sysfs defaults 0 0proc /p

7、roc proc defaults 0 0LABEL=SWAP-sda3 swap swap defaults 0 0/dev/sda4 /data xfs rw,noatime,inode64,allocsize=16m 0 0mount /data修改/data目錄權(quán)限完全給gpadminrootlocalhost # chown -R gpadmin:gpadmin /data5.安裝gpdb執(zhí)行安裝程序，根據(jù)提示選擇yes確認(rèn)即可安裝完畢根據(jù)安裝目錄定義gpadmin環(huán)境變量gpadmincrsz6sbidw01 $ cat .bashrcexport LANG=source /usr

8、/local/greenplum-db/greenplum_path.sh建立集群信任：創(chuàng)建所有網(wǎng)口的列表文件如下：gpadmincrsz6sbidw01 $ cat /data/allhosts mdwmdw-1mdw-2mdw-3mdw-4smdwsmdw-1smdw-2smdw-3smdw-4sdw1sdw1-1sdw1-2sdw1-3sdw1-4sdw2sdw2-1sdw2-2sdw2-3sdw2-4gpadmincrsz6sbidw01 $ gpssh-exkeys -f /data/allhosts STEP 1 of 5 create local ID and authorize

9、 on local hostSTEP 2 of 5 keyscan all hosts and update known_hosts fileSTEP 3 of 5 authorize current user on remote hosts . send to mdw . send to mdw-1 . send to mdw-2 . send to mdw-3 . send to mdw-4 . send to smdw * * Enter password for smdw: . send to smdw-1 . send to smdw-2 . send to smdw-3 . sen

10、d to smdw-4 . send to sdw1 . send to sdw1-1 . send to sdw1-2 . send to sdw1-3 . send to sdw1-4 . send to sdw2 . send to sdw2-1 . send to sdw2-2 . send to sdw2-3 . send to sdw2-4STEP 4 of 5 determine common authentication file contentSTEP 5 of 5 copy authentication files to all remote hosts . finishe

11、d key exchange with mdw . finished key exchange with mdw-1 . finished key exchange with mdw-2 . finished key exchange with mdw-3 . finished key exchange with mdw-4 . finished key exchange with smdw . finished key exchange with smdw-1 . finished key exchange with smdw-2 . finished key exchange with s

12、mdw-3 . finished key exchange with smdw-4 . finished key exchange with sdw1 . finished key exchange with sdw1-1 . finished key exchange with sdw1-2 . finished key exchange with sdw1-3 . finished key exchange with sdw1-4 . finished key exchange with sdw2 . finished key exchange with sdw2-1 . finished

13、 key exchange with sdw2-2 . finished key exchange with sdw2-3 . finished key exchange with sdw2-4INFO completed successfully6.測(cè)試系統(tǒng)磁盤(pán)網(wǎng)絡(luò)性能6.1.磁盤(pán)性能測(cè)試結(jié)果：nohup gpcheckperf -h mdw -h smdw -d /data/primary -d /data/mirror -r ds gpcheckperfio2.loggpadmincrsz6sbidw01 $ cat gpcheckperfio2.log /usr/local/green

14、plum-db/./bin/gpcheckperf -h mdw -h smdw -d /data/primary -d /data/mirror -r ds= disk write avg time (sec): 167.81 disk write tot bytes: 201875652608 disk write tot bandwidth (MB/s): 1147.25 disk write min bandwidth (MB/s): 571.69 smdw disk write max bandwidth (MB/s): 575.56 mdw disk read avg time (

15、sec): 123.12 disk read tot bytes: 201875652608 disk read tot bandwidth (MB/s): 1563.71 disk read min bandwidth (MB/s): 780.46 mdw disk read max bandwidth (MB/s): 783.25 smdw stream tot bandwidth (MB/s): 16734.46 stream min bandwidth (MB/s): 8344.28 smdw stream max bandwidth (MB/s): 8390.18 mdw磁盤(pán)性能基本

16、滿(mǎn)足6塊SAS盤(pán)正常水平。6.2.網(wǎng)絡(luò)性能測(cè)試結(jié)果：創(chuàng)建4個(gè)子網(wǎng)IP的子文件，示例如下：gpadmincrsz6sbidw01 $ vi hostic1mdw-1smdw-1gpadmincrsz6sbidw01 $ nohup gpcheckperf -f hostic1 -r N -d /tmp gpcheckperfnet1.loggpadmincrsz6sbidw01 $ cat gpcheckperfnet1.log/usr/local/greenplum-db/./bin/gpcheckperf -f hostic1 -r N -d /tmp- NETPERF TEST-= RES

17、ULT=Netperf bisection bandwidth testmdw-1 - smdw-1 = 112.410000smdw-1 - mdw-1 = 112.400000Summary:sum = 224.81 MB/secmin = 112.40 MB/secmax = 112.41 MB/secavg = 112.41 MB/secmedian = 112.41 MB/sec網(wǎng)絡(luò)性能基本滿(mǎn)足千兆網(wǎng)絡(luò)正常水平。7.初始化gpdb創(chuàng)建初始化配置文件：gpadmincrsz6sbidw01 $ vi gpinitsystem_config ARRAY_NAME=EMC Greenplu

18、m DWSEG_PREFIX=gpsegPORT_BASE=40000declare -a DATA_DIRECTORY=(/data/primary /data/primary /data/primary /data/primary /data/primary /data/primary /data/primary /data/primary)MASTER_HOSTNAME=mdwMASTER_DIRECTORY=/data/masterMASTER_PORT=5432TRUSTED_SHELL=sshCHECK_POINT_SEGMENTS=8ENCODING=UNICODEMIRROR_

19、PORT_BASE=50000REPLICATION_PORT_BASE=41000MIRROR_REPLICATION_PORT_BASE=51000declare -a MIRROR_DATA_DIRECTORY=(/data/mirror /data/mirror /data/mirror /data/mirror /data/mirror /data/mirror /data/mirror /data/mirror)MACHINE_LIST_FILE=/home/gpadmin/hostfile_gpinitsystem初始化系統(tǒng)：gpadmincrsz6sbidw01 $ gpini

20、tsystem -c gpinitsystem_config -s smdw20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking configuration parameters, please wait.20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Reading Greenplum configuration file gpinitsystem_config20130117:22:47:34:015705 gpin

21、itsystem:crsz6sbidw01:gpadmin-INFO:-Locale has not been set in gpinitsystem_config, will set to default value20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Locale set to en_US.utf820130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-WARN:-Master hostname mdw does not match ho

22、stname output20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking to see if mdw can be resolved on this host20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Can resolve mdw to this host20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-No DATABASE_N

23、AME set, will exit following template1 updates20130117:22:47:34:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-MASTER_MAX_CONNECT not set, will set to default value 25020130117:22:47:35:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking configuration parameters, Completed20130117:22:47:35:01570

24、5 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Commencing multi-home checks, please wait.20130117:22:47:37:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Configuring build for multi-home array20130117:22:47:37:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Commencing multi-home checks, Completed20130117:

25、22:47:37:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Building primary segment instance array, please wait.20130117:22:47:41:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Building group mirror array type , please wait.20130117:22:47:45:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking Maste

26、r host20130117:22:47:45:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking new segment hosts, please wait.20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checking new segment hosts, Completed20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Greenplum Database Cre

27、ation Parameters20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master Configuration20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Mast

28、er instance name = EMC Greenplum DW20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master hostname = mdw20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master port = 543220130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master instance dir = /data/mas

29、ter/gpseg-120130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master LOCALE = en_US.utf820130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Greenplum segment prefix = gpseg20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master Database = 20130117:22:48:02:

30、015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master connections = 25020130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Master buffers = 128000kB20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Segment connections = 75020130117:22:48:02:015705 gpinitsystem:crsz6sbidw0

31、1:gpadmin-INFO:-Segment buffers = 128000kB20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Checkpoint segments = 820130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Encoding = UNICODE20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Postgres param file =

32、Off20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-IN

33、FO:-Ulimit check = Passed20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Array host connect type = Multi hostname per node20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Standby Master = smdw20130117:22:48:02:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Primary se

34、gment # = 420130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total Database segments = 820130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Trusted shell = ssh20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Number segment hosts = 820130117:22:48:03:015705

35、 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Mirror port base = 5000020130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Replicaton port base = 4100020130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Mirror replicaton port base= 5100020130117:22:48:03:015705 gpinitsystem:crsz6

36、sbidw01:gpadmin-INFO:-Mirror segment # = 420130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Mirroring config = ON20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Mirroring type = Group20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:03:01

37、5705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Greenplum Primary Segment Configuration20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-1 /data/primary/gpseg0 40000 2 0 4100020130117:22:48:03:015705 gpinitsystem:crsz6

38、sbidw01:gpadmin-INFO:-sdw1-2 /data/primary/gpseg1 40001 3 1 4100120130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-3 /data/primary/gpseg2 40002 4 2 4100220130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-4 /data/primary/gpseg3 40003 5 3 4100320130117:22:48:03:0

39、15705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-1 /data/primary/gpseg4 40000 6 4 4100020130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-2 /data/primary/gpseg5 40001 7 5 4100120130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-3 /data/primary/gpseg6 40002 8 6

40、4100220130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-4 /data/primary/gpseg7 40003 9 7 4100320130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Greenplum Mirror Segment Configuration20130117:22:48:03:0

41、15705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-2 /data/mirror/gpseg0 50000 10 0 5100020130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-3 /data/mirror/gpseg1 50001 11 1 5100120130117:22:48:03:015705 gpinitsystem:

42、crsz6sbidw01:gpadmin-INFO:-sdw2-4 /data/mirror/gpseg2 50002 12 2 5100220130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw2-1 /data/mirror/gpseg3 50003 13 3 5100320130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-2 /data/mirror/gpseg4 50000 14 4 5100020130117:22:48

43、:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-3 /data/mirror/gpseg5 50001 15 5 5100120130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-4 /data/mirror/gpseg6 50002 16 6 5100220130117:22:48:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-sdw1-1 /data/mirror/gpseg7 50003

44、17 7 51003Continue with Greenplum creation Yy/Nny20130117:22:52:37:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Building the Master instance database, please wait.20130117:22:53:05:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Starting the Master in admin mode20130117:22:53:19:015705 gpinitsystem

45、:crsz6sbidw01:gpadmin-INFO:-Commencing parallel build of primary segment instances20130117:22:53:19:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Spawning parallel processes batch 1, please wait.20130117:22:53:19:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Waiting for parallel processes batch 1,

46、 please wait.20130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Parallel process exit status20130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:

47、-Total processes marked as completed = 820130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total processes marked as killed = 020130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total processes marked as failed = 020130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin

48、-INFO:-20130117:22:54:52:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Commencing parallel build of mirror segment instances20130117:22:54:53:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Spawning parallel processes batch 1, please wait.20130117:22:54:53:015705 gpinitsystem:crsz6sbidw01:gpadmin-IN

49、FO:-Waiting for parallel processes batch 1, please wait.20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Parallel process exit status20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:03:015

50、705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total processes marked as completed = 820130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total processes marked as killed = 020130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Total processes marked as failed = 020130117:22:55:

51、03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Deleting distributed backout files20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Removing back out file20130117:22:55:03:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:

52、-No errors generated from parallel processes20130117:22:55:04:015705 gpinitsystem:crsz6sbidw01:gpadmin-INFO:-Starting initialization of standby master smdw20130117:22:55:05:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Validating environment and parameters for standby initialization.20130117:22:55

53、:05:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Checking for filespace directory /data/master/gpseg-1 on smdw20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum standby master initialization parameters20130

54、117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum master hostname = crsz6sbidw0120130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum master data directory = /data/master/gpseg-120130117:22:5

55、5:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum master port = 543220130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum standby master hostname = smdw20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum standby master port = 543220130117:22

56、:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum standby master data directory = /data/master/gpseg-120130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum update system catalog = On20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Greenplum stop

57、database mode = smart20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:- Filespace locations20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-20130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-I

58、NFO:-pg_system - /data/master/gpseg-120130117:22:55:06:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Syncing Greenplum Database extensions to standby20130117:22:55:08:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-The packages on smdw are consistent.20130117:22:55:08:006480 gpinitstandby:crsz6sbi

59、dw01:gpadmin-INFO:-Stopping master.20130117:22:55:11:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Updating pg_hba.conf file.20130117:22:55:12:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Starting master in utility mode.20130117:22:55:15:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Adding st

60、andby master to catalog.20130117:22:55:15:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Database catalog updated successfully.20130117:22:55:15:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Stopping master.20130117:22:55:19:006480 gpinitstandby:crsz6sbidw01:gpadmin-INFO:-Forcing changed blocks t