[gpadmin@mdw conf]$ gpinitsystem -c /home/gpadmin/conf/gp_init_config -h /home/gpadmin/conf/host_gpinits -B 6
20170716:18:31:59:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file /home/gpadmin/conf/gp_init_config
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in /home/gpadmin/conf/gp_init_config, will set to default value
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20170716:18:32:00:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
..
20170716:18:32:01:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array
20170716:18:32:01:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20170716:18:32:01:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
............
20170716:18:32:08:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Building group mirror array type , please wait...
............
20170716:18:32:15:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host
20170716:18:32:16:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
........................
20170716:18:32:34:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, Completed
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master Configuration
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance name = EMC Greenplum DW
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master hostname = mdw
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master port = 5432
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance dir = /data/master/gpseg-1
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum segment prefix = gpseg
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master Database =
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master connections = 250
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master buffers = 128000kB
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Segment connections = 750
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Segment buffers = 128000kB
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Checkpoint segments = 8
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Encoding = UNICODE
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Postgres param file = Off
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Ulimit check = Passed
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [1] = ::1
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [2] = 172.16.100.1
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [3] = 192.168.122.1
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [4] = 192.168.1.83
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [5] = fe80::250:56ff:fe80:3efa
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [6] = fe80::250:56ff:fe80:47af
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master = Not Configured
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Primary segment # = 6
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total Database segments = 12
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Trusted shell = ssh
20170716:18:32:35:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Number segment hosts = 2
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Mirror port base = 50000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Replicaton port base = 41000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Mirror replicaton port base= 51000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Mirror segment # = 6
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring config = ON
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring type = Group
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg0 40000 2 0 41000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg1 40001 3 1 41001
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg2 40002 4 2 41002
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg3 40003 5 3 41003
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg4 40004 6 4 41004
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/primary/gpseg5 40005 7 5 41005
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg6 40000 8 6 41000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg7 40001 9 7 41001
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg8 40002 10 8 41002
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg9 40003 11 9 41003
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg10 40004 12 10 41004
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/primary/gpseg11 40005 13 11 41005
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg0 50000 14 0 51000
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg1 50001 15 1 51001
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg2 50002 16 2 51002
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg3 50003 17 3 51003
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg4 50004 18 4 51004
20170716:18:32:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 /data/mirror/gpseg5 50005 19 5 51005
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg6 50000 20 6 51000
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg7 50001 21 7 51001
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg8 50002 22 8 51002
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg9 50003 23 9 51003
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg10 50004 24 10 51004
20170716:18:32:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 /data/mirror/gpseg11 50005 25 11 51005
Continue with Greenplum creation Yy|Nn (default=N):
> y
20170716:18:32:48:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Building the Master instance database, please wait...
20170716:18:33:08:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Starting the Master in admin mode
20170716:18:33:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20170716:18:33:36:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
......
20170716:18:33:37:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.................................
20170716:18:34:10:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [2], please wait...
......
20170716:18:34:10:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [2], please wait...
..............................
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed = 12
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed = 0
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed = 0
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20170716:18:34:41:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
......
20170716:18:34:42:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.............
20170716:18:34:55:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [2], please wait...
......
20170716:18:34:55:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [2], please wait...
.............
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed = 12
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed = 0
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed = 0
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Deleting distributed backout files
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Removing back out file
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-No errors generated from parallel processes
20170716:18:35:09:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /data/master/gpseg-1
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.0.0-beta.3 build commit:e87dfaec0080490c500e02c4e4c913d14a06e4d8'
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-There are 0 connections to the database
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Master host=mdw
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20170716:18:35:10:002146 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1
20170716:18:35:11:002146 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20170716:18:35:11:002146 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /data/master/gpseg-1
20170716:18:35:12:002233 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /data/master/gpseg-1
20170716:18:35:12:002233 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20170716:18:35:12:002233 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.0.0-beta.3 build commit:e87dfaec0080490c500e02c4e4c913d14a06e4d8'
20170716:18:35:12:002233 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20170716:18:35:12:002233 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20170716:18:35:13:002233 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20170716:18:35:13:002233 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170716:18:35:13:002233 gpstart:mdw:gpadmin-[INFO]:-Setting new master era
20170716:18:35:13:002233 gpstart:mdw:gpadmin-[INFO]:-Master Started...
20170716:18:35:13:002233 gpstart:mdw:gpadmin-[INFO]:-Shutting down master
20170716:18:35:15:002233 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
.............
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-Process results...
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:- Successful segment starts = 24
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:- Failed segment starts = 0
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-Successfully started 24 of 24 segment instances
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170716:18:35:28:002233 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /data/master/gpseg-1
20170716:18:35:29:002233 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active
20170716:18:35:29:002233 gpstart:mdw:gpadmin-[INFO]:-No standby master configured. skipping...
20170716:18:35:29:002233 gpstart:mdw:gpadmin-[INFO]:-Database successfully started
20170716:18:35:29:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[WARN]:-were generated during the array creation
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Please review contents of log file
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20170716.log
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-To determine level of criticality
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-that was called today!
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database instance successfully created
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-To complete the environment configuration, please
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/data/master/gpseg-1"
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:- or, use -d /data/master/gpseg-1 option for the Greenplum scripts
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:- Example gpstate -d /data/master/gpseg-1
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20170716.log
20170716:18:35:30:010088 gpinitsystem:mdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Review options for gpinitstandby
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-The Master /data/master/gpseg-1/pg_hba.conf post gpinitsystem
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-new array must be explicitly added to this file
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20170716:18:35:31:010088 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
[gpadmin@mdw conf]$
greenplum-db-5.0.0-beta.3-rhel6-x86_64
最新推荐文章于 2024-09-23 09:30:00 发布
本日志记录了使用gpinitsystem命令初始化Greenplum数据库的过程,包括配置参数检查、多主机检查、构建主备实例等步骤,并最终成功创建了一个包含主节点和多个分段节点的Greenplum集群。
摘要由CSDN通过智能技术生成