單機機器為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]:-------------------------------------------------------

總結

以上是生活随笔為你收集整理的greenplum单机版初始化日志的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。