单机机器为192.168.31.200
启动思路为:
[gpadmin@sggp gpconfigs]$ gpinitsystem -c /home/gpadmin/gpinitsystem_config
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking configuration parameters, please wait…
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Reading Greenplum configuration file /home/gpadmin/gpinitsystem_config
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Locale has not been set in /home/gpadmin/gpinitsystem_config, will set to default value
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Locale set to en_US.utf8
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[WARN]:-Master hostname mdw does not match hostname output
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking to see if mdw can be resolved on this host
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Can resolve mdw to this host
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking configuration parameters, Completed
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Commencing multi-home checks, please wait…
.
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Configuring build for standard array
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20180907:11:53:18:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Building primary segment instance array, please wait…
.
20180907:11:53:19:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Building group mirror array type , please wait…
.
20180907:11:53:20:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking Master host
20180907:11:53:20:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking new segment hosts, please wait…
..
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checking new segment hosts, Completed
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master Configuration
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master instance name = Greenplum
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master hostname = mdw
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master port = 5432
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master instance dir = /home/gpadmin/master/gpseg-1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Greenplum segment prefix = gpseg
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master Database =
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master connections = 250
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master buffers = 128000kB
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Segment connections = 750
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Segment buffers = 128000kB
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Checkpoint segments = 256
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Encoding = UNICODE
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Postgres param file = Off
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-HEAP_CHECKSUM is = on
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Ulimit check = Passed
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master IP address [1] = ::1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master IP address [2] = 192.168.31.200
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Master IP address [3] = fe80::a00:27ff:fe57:c581
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Standby Master = Not Configured
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Primary segment # = 1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total Database segments = 1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Trusted shell = ssh
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Number segment hosts = 1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Mirror port base = 50000
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Replicaton port base = 41000
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Mirror replicaton port base= 51000
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Mirror segment # = 1
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Mirroring config = ON
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Mirroring type = Group
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————-
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————-
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-sdw /home/gpadmin/d1/gpseg0 40000 2 0 41000
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:—————————————
20180907:11:53:23:007876 gpinitsystem:sggp:gpadmin-[INFO]:-sdw /home/gpadmin/mirror1/gpseg0 50000 3 0 51000
Continue with Greenplum creation Yy|Nn (default=N):
> Y
20180907:11:54:13:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Building the Master instance database, please wait…
20180907:11:54:17:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Starting the Master in admin mode
20180907:11:54:21:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20180907:11:54:21:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait…
.
20180907:11:54:21:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait…
……………..
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Parallel process exit status
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as completed = 1
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as killed = 0
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as failed = 0
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait…
.
20180907:11:54:39:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait…
………………
20180907:11:54:57:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:57:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Parallel process exit status
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as completed = 1
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as killed = 0
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Total processes marked as failed = 0
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:————————————————
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Deleting distributed backout files
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Removing back out file
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-No errors generated from parallel processes
20180907:11:54:58:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /home/gpadmin/master/gpseg-1
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Gathering information and validating the environment…
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Obtaining Segment details from master…
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Greenplum Version: ‘postgres (Greenplum Database) 5.8.0 build commit:09b07657655d1b330c392c80cceb00fd0a21fd46’
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-There are 0 connections to the database
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=’immediate’
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Master host=sggp
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20180907:11:54:58:011510 gpstop:sggp:gpadmin-[INFO]:-Master segment instance directory=/home/gpadmin/master/gpseg-1
20180907:11:54:59:011510 gpstop:sggp:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20180907:11:54:59:011510 gpstop:sggp:gpadmin-[INFO]:-Terminating processes for segment /home/gpadmin/master/gpseg-1
20180907:11:54:59:011536 gpstart:sggp:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /home/gpadmin/master/gpseg-1
20180907:11:54:59:011536 gpstart:sggp:gpadmin-[INFO]:-Gathering information and validating the environment…
20180907:11:54:59:011536 gpstart:sggp:gpadmin-[INFO]:-Greenplum Binary Version: ‘postgres (Greenplum Database) 5.8.0 build commit:09b07657655d1b330c392c80cceb00fd0a21fd46’
20180907:11:54:59:011536 gpstart:sggp:gpadmin-[INFO]:-Greenplum Catalog Version: ‘301705051’
20180907:11:54:59:011536 gpstart:sggp:gpadmin-[INFO]:-Starting Master instance in admin mode
20180907:11:55:00:011536 gpstart:sggp:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20180907:11:55:00:011536 gpstart:sggp:gpadmin-[INFO]:-Obtaining Segment details from master…
20180907:11:55:00:011536 gpstart:sggp:gpadmin-[INFO]:-Setting new master era
20180907:11:55:00:011536 gpstart:sggp:gpadmin-[INFO]:-Master Started…
20180907:11:55:00:011536 gpstart:sggp:gpadmin-[INFO]:-Shutting down master
20180907:11:55:01:011536 gpstart:sggp:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait…
..
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:-Process results…
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:—————————————————–
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:- Successful segment starts = 2
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:- Failed segment starts = 0
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:—————————————————–
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:—————————————————–
20180907:11:55:03:011536 gpstart:sggp:gpadmin-[INFO]:-Starting Master instance sggp directory /home/gpadmin/master/gpseg-1
20180907:11:55:05:011536 gpstart:sggp:gpadmin-[INFO]:-Command pg_ctl reports Master sggp instance active
20180907:11:55:05:011536 gpstart:sggp:gpadmin-[INFO]:-No standby master configured. skipping…
20180907:11:55:05:011536 gpstart:sggp:gpadmin-[INFO]:-Database successfully started
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[WARN]:-*******************************************************
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[WARN]:-were generated during the array creation
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Please review contents of log file
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20180907.log
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-To determine level of criticality
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-that was called today!
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[WARN]:-*******************************************************
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Greenplum Database instance successfully created
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:——————————————————-
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-To complete the environment configuration, please
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-2. Add “export MASTER_DATA_DIRECTORY=/home/gpadmin/master/gpseg-1”
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:- or, use -d /home/gpadmin/master/gpseg-1 option for the Greenplum scripts
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:- Example gpstate -d /home/gpadmin/master/gpseg-1
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20180907.log
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Review options for gpinitstandby
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:——————————————————-
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-The Master /home/gpadmin/master/gpseg-1/pg_hba.conf post gpinitsystem
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-new array must be explicitly added to this file
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20180907:11:55:05:007876 gpinitsystem:sggp:gpadmin-[INFO]:——————————————————-