GreenPlum集群初始化

gpadmin@master:~/gpconfigs$ source /opt/greenplum-db-6.21.0/greenplum_path.sh 
gpadmin@master:~/gpconfigs$ $ cd ~
Fatal Python error: Py_Initialize: Unable to get the locale encoding
ModuleNotFoundError: No module named 'encodings'

Current thread 0x00007fb170f8d740 (most recent call first):
Aborted (core dumped)
gpadmin@master:~/gpconfigs$ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem
20220707:07:18:23:001455 gpinitsystem:master:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20220707:07:18:23:001455 gpinitsystem:master:gpadmin-[FATAL]:-Configuration file gpconfigs/gpinitsystem_config does not exist. Script Exiting!
gpadmin@master:~/gpconfigs$ cd ..
gpadmin@master:~$ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Reading Greenplum configuration file gpconfigs/gpinitsystem_config
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Locale has not been set in gpconfigs/gpinitsystem_config, will set to default value
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Locale set to en_US.utf8
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[WARN]:-Master hostname 10.3.23.227 does not match hostname output
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking to see if 10.3.23.227 can be resolved on this host
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Can resolve 10.3.23.227 to this host
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[WARN]:-Master open file limit is 1024 should be >= 65535
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking configuration parameters, Completed
20220707:07:18:34:001621 gpinitsystem:master:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
..
20220707:07:18:36:001621 gpinitsystem:master:gpadmin-[INFO]:-Configuring build for standard array
20220707:07:18:36:001621 gpinitsystem:master:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20220707:07:18:36:001621 gpinitsystem:master:gpadmin-[INFO]:-Building primary segment instance array, please wait...
......
20220707:07:18:43:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking Master host
20220707:07:18:44:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking new segment hosts, please wait...
20220707:07:18:45:001621 gpinitsystem:master:gpadmin-[WARN]:-Host 10.3.23.227 open files limit is 1024 should be >= 65535
20220707:07:18:47:001621 gpinitsystem:master:gpadmin-[WARN]:-Host 10.3.23.227 open files limit is 1024 should be >= 65535
......
20220707:07:19:03:001621 gpinitsystem:master:gpadmin-[INFO]:-Checking new segment hosts, Completed
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:---------------------------------------
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master Configuration
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:---------------------------------------
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master instance name       = Greenplum Data Platform
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master hostname            = 10.3.23.227
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master port                = 5432
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master instance dir        = /data/master/gpseg-1
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master Database            = 
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master connections         = 250
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master buffers             = 128000kB
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Segment connections        = 750
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Segment buffers            = 128000kB
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Checkpoint segments        = 8
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Encoding                   = UNICODE
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Postgres param file        = Off
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Initdb to be used          = /opt/greenplum-db-6.21.0/bin/initdb
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /opt/greenplum-db-6.21.0/lib
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[WARN]:-Ulimit check               = Warnings generated, see log file <<<<<
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master IP address [1]      = ::1
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master IP address [2]      = 10.3.23.227
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Master IP address [3]      = fe80::90e5:aff:fe05:3bc
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Standby Master             = Not Configured
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Number of primary segments = 3
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Total Database segments    = 6
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Trusted shell              = ssh
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Number segment hosts       = 2
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Mirroring config           = OFF
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:----------------------------------------
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:----------------------------------------
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment01  6000    segment01   /data/primary/gpseg0    2
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment01  6001    segment01   /data/primary/gpseg1    3
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment01  6002    segment01   /data/primary/gpseg2    4
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment02  6000    segment02   /data/primary/gpseg3    5
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment02  6001    segment02   /data/primary/gpseg4    6
20220707:07:19:04:001621 gpinitsystem:master:gpadmin-[INFO]:-segment02  6002    segment02   /data/primary/gpseg5    7

Continue with Greenplum creation Yy|Nn (default=N):
> y
20220707:07:22:40:001621 gpinitsystem:master:gpadmin-[INFO]:-Building the Master instance database, please wait...
20220707:07:22:46:001621 gpinitsystem:master:gpadmin-[INFO]:-Starting the Master in admin mode
20220707:07:22:46:001621 gpinitsystem:master:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20220707:07:22:46:001621 gpinitsystem:master:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
......
20220707:07:22:47:001621 gpinitsystem:master:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
....................................
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:------------------------------------------------
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Parallel process exit status
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:------------------------------------------------
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Total processes marked as completed           = 6
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Total processes marked as killed              = 0
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Total processes marked as failed              = 0
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:------------------------------------------------
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Removing back out file
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-No errors generated from parallel processes
20220707:07:23:23:001621 gpinitsystem:master:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -m -d /data/master/gpseg-1
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Gathering information and validating the environment...
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Obtaining Segment details from master...
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source'
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1
20220707:07:23:23:006349 gpstop:master:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20220707:07:23:24:006349 gpstop:master:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20220707:07:23:24:006349 gpstop:master:gpadmin-[INFO]:-Terminating processes for segment /data/master/gpseg-1
20220707:07:23:24:006372 gpstart:master:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /data/master/gpseg-1
20220707:07:23:24:006372 gpstart:master:gpadmin-[INFO]:-Gathering information and validating the environment...
20220707:07:23:24:006372 gpstart:master:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source'
20220707:07:23:24:006372 gpstart:master:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20220707:07:23:24:006372 gpstart:master:gpadmin-[INFO]:-Starting Master instance in admin mode
20220707:07:23:25:006372 gpstart:master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220707:07:23:25:006372 gpstart:master:gpadmin-[INFO]:-Obtaining Segment details from master...
20220707:07:23:25:006372 gpstart:master:gpadmin-[INFO]:-Setting new master era
20220707:07:23:25:006372 gpstart:master:gpadmin-[INFO]:-Master Started...
20220707:07:23:25:006372 gpstart:master:gpadmin-[INFO]:-Shutting down master
20220707:07:23:26:006372 gpstart:master:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
.
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-Process results...
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-   Successful segment starts                                            = 6
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-Successfully started 6 of 6 segment instances 
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:07:23:27:006372 gpstart:master:gpadmin-[INFO]:-Starting Master instance 10.3.23.227 directory /data/master/gpseg-1 
20220707:07:23:28:006372 gpstart:master:gpadmin-[INFO]:-Command pg_ctl reports Master 10.3.23.227 instance active
20220707:07:23:28:006372 gpstart:master:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20220707:07:23:28:006372 gpstart:master:gpadmin-[INFO]:-No standby master configured.  skipping...
20220707:07:23:28:006372 gpstart:master:gpadmin-[INFO]:-Database successfully started
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[WARN]:-*******************************************************
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[WARN]:-were generated during the array creation
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Please review contents of log file
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20220707.log
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-To determine level of criticality
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-that was called today!
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[WARN]:-*******************************************************
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Greenplum Database instance successfully created
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-------------------------------------------------------
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-To complete the environment configuration, please 
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/data/master/gpseg-1"
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-   or, use -d /data/master/gpseg-1 option for the Greenplum scripts
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-   Example gpstate -d /data/master/gpseg-1
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20220707.log
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Review options for gpinitstandby
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-------------------------------------------------------
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-The Master /data/master/gpseg-1/pg_hba.conf post gpinitsystem
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-new array must be explicitly added to this file
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-located in the /opt/greenplum-db-6.21.0/docs directory
20220707:07:23:28:001621 gpinitsystem:master:gpadmin-[INFO]:-------------------------------------------------------
gpadmin@master:~$ gpconfig -s TimeZone
Values on all segments are consistent
GUC          : TimeZone
Master  value: Etc/UTC
Segment value: Etc/UTC

初始化后设置时区timezone为Asia/Shanghai，需要重启集群才能生效（gpstop -ra，需要先设置MASTER_DATA_DIRECTORY=/data/master/gpseg-1环境变量）

gpadmin@master:/data/master$ export MASTER_DATA_DIRECTORY = /data/master/gpseg-1
-su: export: `=': not a valid identifier
-su: export: `/data/master/gpseg-1': not a valid identifier
gpadmin@master:/data/master$ export MASTER_DATA_DIRECTORY=/data/master/gpseg-1
gpadmin@master:/data/master$ gpstop -ra
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Starting gpstop with args: -ra
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Gathering information and validating the environment...
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Obtaining Segment details from master...
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source'
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1
20220707:08:09:39:006873 gpstop:master:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-Terminating processes for segment /data/master/gpseg-1
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-No standby master host configured
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-Targeting dbid [2, 3, 4, 5, 6, 7] for shutdown
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20220707:08:09:40:006873 gpstop:master:gpadmin-[INFO]:-0.00% of jobs completed
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-100.00% of jobs completed
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-   Segments stopped successfully      = 6
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-Successfully shutdown 6 of 6 segment instances 
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-No leftover gpmmon process found
20220707:08:09:41:006873 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20220707:08:09:42:006873 gpstop:master:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20220707:08:09:42:006873 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover shared memory
20220707:08:09:43:006873 gpstop:master:gpadmin-[INFO]:-Restarting System...
gpadmin@master:/data/master$ gpconfig -s TimeZone
Values on all segments are consistent
GUC          : TimeZone
Master  value: Etc/UTC
Segment value: Etc/UTC
gpadmin@master:/data/master$ gpconfig -c TimeZone -v 'Asia/Shanghai'
20220707:08:12:27:007358 gpconfig:master:gpadmin-[INFO]:-completed successfully with parameters '-c TimeZone -v Asia/Shanghai'
gpadmin@master:/data/master$ gpconfig -s TimeZone
Values on all segments are consistent
GUC          : TimeZone
Master  value: Etc/UTC
Segment value: Etc/UTC
gpadmin@master:/data/master$ gpstop -ra
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Starting gpstop with args: -ra
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Gathering information and validating the environment...
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Obtaining Segment details from master...
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.21.0 build commit:d0087e3b24c54d203ca8bb315559205f13cd6393 Open Source'
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1
20220707:08:13:15:007571 gpstop:master:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-Terminating processes for segment /data/master/gpseg-1
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-No standby master host configured
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-Targeting dbid [2, 3, 4, 5, 6, 7] for shutdown
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20220707:08:13:16:007571 gpstop:master:gpadmin-[INFO]:-0.00% of jobs completed
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-100.00% of jobs completed
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-   Segments stopped successfully      = 6
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-----------------------------------------------------
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-Successfully shutdown 6 of 6 segment instances 
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-No leftover gpmmon process found
20220707:08:13:17:007571 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20220707:08:13:18:007571 gpstop:master:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20220707:08:13:18:007571 gpstop:master:gpadmin-[INFO]:-Cleaning up leftover shared memory
20220707:08:13:20:007571 gpstop:master:gpadmin-[INFO]:-Restarting System...
gpadmin@master:/data/master$ gpconfig -s TimeZone
Values on all segments are consistent
GUC          : TimeZone
Master  value: Asia/Shanghai
Segment value: Asia/Shanghai