注意:如果master配置了standby master,添加的segment必须要有mirror segment存在,否则报错。
1查看某张表的数据分布情况
tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id; gp_segment_id | count ---------------+--------- 0 | 1024552 (1 row)
2关闭iptables和selinux
3root用户配置ssh互信
略
4创建gpadmin用户
/usr/sbin/useradd gpadmin -d /home/gpadmin -s /bin/bash
5gpadmin用户配置ssh互信
略
6编辑new_hosts_file文件
该文件中仅包含新增节点主机名
7创建inputfile
[gpadmin@hadoop02 ~]$ gpexpand -f new_hosts_file -D gpadmin 20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1' 20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'Postgresql 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56' 20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state System Expansion is used to add segments to an existing GPDB array. gpexpand did not detect a System Expansion that is in progress. Before initiating a System Expansion,you need to provision and burn-in the new hardware. Please be sure to run gpcheckperf/gpcheckos to make sure the new hardware is working properly. Please refer to the Admin Guide for more information. Would you like to initiate a new System Expansion Yy|Nn (default=N): > y By default,new hosts are configured with the same number of primary segments as existing hosts. Optionally,you can increase the number of segments per host. For example,if existing hosts have two primary segments,entering a value of 2 will initialize two additional segments on existing hosts,and four segments on new hosts. In addition,mirror segments will be added for these new primary segments if mirroring is enabled. How many new primary segments per host do you want to add? (default=0): > Generating configuration file... 20160928:17:04:12:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Generating input file... Input configuration files were written to 'gpexpand_inputfile_20160928_170412' and 'None'. Please review the file and make sure that it is correct then re-run with: gpexpand -i gpexpand_inputfile_20160928_170412 -D gpadmin 20160928:17:04:12:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...
8使用input file添加节点
[gpadmin@hadoop02 ~]$ gpexpand -i gpexpand_inputfile_20160928_170412 -D gpadmin 20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1' 20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'Postgresql 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56' 20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state 20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Readying Greenplum Database for a new expansion 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database gpadmin for unalterable tables... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database postgres for unalterable tables... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database tutorial for unalterable tables... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database template1 for unalterable tables... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database gpadmin for tables with unique indexes... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database postgres for tables with unique indexes... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database tutorial for tables with unique indexes... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database template1 for tables with unique indexes... 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Syncing Greenplum Database extensions 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-The packages on hadoop07 are consistent. 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating segment template 20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-VACUUM FULL on the catalog tables 20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting copy of segment dbid 1 to location /data/master/gpexpand_09282016_15600 20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying postgresql.conf from existing segment into template 20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying pg_hba.conf from existing segment into template 20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Adding new segments into template pg_hba.conf 20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating schema tar file 20160928:17:05:10:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Distributing template tar file to new hosts 20160928:17:05:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segments (primary) 20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segments (mirror) 20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Backing up pg_hba.conf file on original segments 20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying new pg_hba.conf file to original segments 20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring original segments 20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Cleaning up temporary template files 20160928:17:05:20:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database in restricted mode 20160928:17:05:26:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping database 20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking if Transaction filespace was moved 20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking if Temporary filespace was moved 20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segment filespaces 20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Cleaning up databases in new segments. 20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting master in utility mode 20160928:17:05:43:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping master in utility mode 20160928:17:05:47:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database in restricted mode 20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating expansion schema 20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database gpadmin 20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database postgres 20160928:17:05:54:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database tutorial 20160928:17:05:55:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database template1 20160928:17:05:55:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping Greenplum Database 20160928:17:06:12:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-************************************************ 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Initialization of the system expansion complete. 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-To begin table expansion onto the new segments 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-rerun gpexpand 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-************************************************ 20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...
节点添加成功,但数据没有重新分布。
tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id; gp_segment_id | count ---------------+--------- 0 | 1024552 (1 row)
9重新分布数据
[gpadmin@hadoop02 ~]$ gpexpand -d 60:00:00 -D gpadmin 20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1' 20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'Postgresql 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56' 20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state 20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.hdfs01 is 'id' 20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.hdfs01 20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.hdfs01 20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.faa_load_errors is 'None' 20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.faa_load_errors 20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.faa_load_errors 20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.faa_otp_load is 'flt_year,flt_month,flt_dayofmonth' 20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.faa_otp_load 20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.faa_otp_load 20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_r is 'uniquecarrier,flightnum' 20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_r 20160928:17:12:01:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_r 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_airports is 'airport_code' 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_airports 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_airports 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_wac is 'wac' 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_wac 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_wac 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_airlines is 'airlineid' 20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_airlines 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_airlines 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_cancellation_codes is 'cancel_code' 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_cancellation_codes 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_cancellation_codes 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_delay_groups is 'delay_group_code' 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_delay_groups 20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_delay_groups 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_distance_groups is 'distance_group_code' 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_distance_groups 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_distance_groups 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_17 is 'uniquecarrier,flightnum' 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_17 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_17 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_16 is 'uniquecarrier,flightnum' 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_16 20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_16 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_15 is 'uniquecarrier,flightnum' 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_15 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_15 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_14 is 'uniquecarrier,flightnum' 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_14 20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_14 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_13 is 'uniquecarrier,flightnum' 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_13 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_13 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_12 is 'uniquecarrier,flightnum' 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_12 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_12 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_11 is 'uniquecarrier,flightnum' 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_11 20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_11 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_10 is 'uniquecarrier,flightnum' 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_10 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_10 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_9 is 'uniquecarrier,flightnum' 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_9 20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_9 20160928:17:12:08:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_8 is 'uniquecarrier,flightnum' 20160928:17:12:08:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_8 20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_8 20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_7 is 'uniquecarrier,flightnum' 20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_7 20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_7 20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_6 is 'uniquecarrier,flightnum' 20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_6 20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_6 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_5 is 'uniquecarrier,flightnum' 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_5 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_5 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_4 is 'uniquecarrier,flightnum' 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_4 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_4 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_3 is 'uniquecarrier,flightnum' 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_3 20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_3 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_2 is 'uniquecarrier,flightnum' 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_2 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_2 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_1 is 'uniquecarrier,flightnum' 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_1 20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_1 20160928:17:12:20:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.sample is 'id' 20160928:17:12:20:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.sample 20160928:17:12:23:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.sample 20160928:17:12:28:017026 gpexpand:hadoop02:gpadmin-[INFO]:-EXPANSION COMPLETED SUCCESSFULLY 20160928:17:12:28:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...
查看数据分布情况
tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id; gp_segment_id | count ---------------+-------- 1 | 510480 0 | 514072 (2 rows)
发现已均匀分部在各个节点
10清理expansion schema
[gpadmin@hadoop02 ~]$ gpexpand -c -D gpadmin 20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1' 20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'Postgresql 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56' 20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state Do you want to dump the gpexpand.status_detail table to file? Yy|Nn (default=Y): > y 20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Dumping gpexpand.status_detail to /data/master/gpseg-1/gpexpand.status_detail 20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Removing gpexpand schema 20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Cleanup Finished. exiting...原文链接:https://www.f2er.com/postgresql/194346.html