ITPub博客

首页 > 大数据 > 数据分析 > 【greenplum】greenplum集群数据库初始化输出内容样例

【greenplum】greenplum集群数据库初始化输出内容样例

原创 数据分析 作者:xysoul_云龙 时间:2020-06-02 09:44:25 0 删除 编辑
--1管理节点,3个计算节点,共计6个segment数据库
[gpadmin@gpms conf]$ gpinitsystem -c gpinitsystem_config -h seg_hosts -s gps3 -S
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Locale set to en_US.utf8
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20200602:08:26:55:051207 gpinitsystem:gpms:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20200602:08:26:58:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checking configuration parameters, Completed
20200602:08:26:58:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
...
20200602:08:27:01:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Configuring build for standard array
20200602:08:27:01:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Sufficient hosts for spread mirroring request
20200602:08:27:01:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20200602:08:27:01:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Building primary segment instance array, please wait...
[BEGIN]
2020/6/2 8:26:04
....
20200602:08:27:12:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Building spread mirror array type , please wait...
......
20200602:08:27:24:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checking Master host
20200602:08:27:24:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checking new segment hosts, please wait...
............
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checking new segment hosts, Completed
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:---------------------------------------
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master Configuration
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:---------------------------------------
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master instance name       = Greenplum Data Platform
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master hostname            = gpms
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master port                = 2345
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master instance dir        = /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master Database            = 
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master connections         = 250
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master buffers             = 128000kB
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Segment connections        = 750
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Segment buffers            = 128000kB
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Checkpoint segments        = 8
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Encoding                   = UNICODE
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Postgres param file        = Off
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Initdb to be used          = /opt/greenplum/greenplum-db/./bin/initdb
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /opt/greenplum/greenplum-db/./lib
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Ulimit check               = Passed
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master IP address [1]      = ::1
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master IP address [2]      = 192.168.80.161
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Master IP address [3]      = fe80::20c:29ff:fe1d:2b2c
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Standby Master             = gps3
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Primary segment #          = 2
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Standby IP address         = ::1
20200602:08:28:17:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Standby IP address         = 192.168.80.164
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Standby IP address         = fe80::20c:29ff:fe55:eed8
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total Database segments    = 6
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Trusted shell              = /usr/bin/ssh
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Number segment hosts       = 3
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Mirror port base           = 43000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Replicaton port base       = 34000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Mirror replicaton port base= 44000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Mirror segment #           = 2
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Mirroring config           = ON
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Mirroring type             = Spread
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:----------------------------------------
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:----------------------------------------
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps1 	/home/gpadmin/gpdata/gpdatap1/gpseg0 	33000 	2 	0 	34000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps1 	/home/gpadmin/gpdata/gpdatap2/gpseg1 	33001 	3 	1 	34001
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps2 	/home/gpadmin/gpdata/gpdatap1/gpseg2 	33000 	4 	2 	34000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps2 	/home/gpadmin/gpdata/gpdatap2/gpseg3 	33001 	5 	3 	34001
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps3 	/home/gpadmin/gpdata/gpdatap1/gpseg4 	33000 	6 	4 	34000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps3 	/home/gpadmin/gpdata/gpdatap2/gpseg5 	33001 	7 	5 	34001
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:---------------------------------------
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:---------------------------------------
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps2 	/home/gpadmin/gpdata/gpdatam1/gpseg0 	43000 	8 	0 	44000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps3 	/home/gpadmin/gpdata/gpdatam2/gpseg1 	43001 	9 	1 	44001
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps3 	/home/gpadmin/gpdata/gpdatam1/gpseg2 	43000 	10 	2 	44000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps1 	/home/gpadmin/gpdata/gpdatam2/gpseg3 	43001 	11 	3 	44001
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps1 	/home/gpadmin/gpdata/gpdatam1/gpseg4 	43000 	12 	4 	44000
20200602:08:28:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-gps2 	/home/gpadmin/gpdata/gpdatam2/gpseg5 	43001 	13 	5 	44001
Continue with Greenplum creation Yy|Nn (default=N):
> Y
20200602:08:28:24:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Building the Master instance database, please wait...
20200602:08:28:38:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Starting the Master in admin mode
20200602:08:28:51:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20200602:08:28:51:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
......
20200602:08:28:51:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
........................
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Parallel process exit status
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as completed           = 6
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as killed              = 0
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as failed              = 0
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
......
20200602:08:29:16:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
................
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Parallel process exit status
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as completed           = 6
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as killed              = 0
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Total processes marked as failed              = 0
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:------------------------------------------------
20200602:08:29:32:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Deleting distributed backout files
20200602:08:29:33:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Removing back out file
20200602:08:29:33:051207 gpinitsystem:gpms:gpadmin-[INFO]:-No errors generated from parallel processes
20200602:08:29:33:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Gathering information and validating the environment...
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Obtaining Segment details from master...
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-There are 0 connections to the database
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Master host=gpms
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20200602:08:29:33:058328 gpstop:gpms:gpadmin-[INFO]:-Master segment instance directory=/home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:34:058328 gpstop:gpms:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20200602:08:29:35:058328 gpstop:gpms:gpadmin-[INFO]:-Terminating processes for segment /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:35:058354 gpstart:gpms:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:35:058354 gpstart:gpms:gpadmin-[INFO]:-Gathering information and validating the environment...
20200602:08:29:35:058354 gpstart:gpms:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20200602:08:29:35:058354 gpstart:gpms:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20200602:08:29:35:058354 gpstart:gpms:gpadmin-[INFO]:-Starting Master instance in admin mode
20200602:08:29:37:058354 gpstart:gpms:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20200602:08:29:37:058354 gpstart:gpms:gpadmin-[INFO]:-Obtaining Segment details from master...
20200602:08:29:37:058354 gpstart:gpms:gpadmin-[INFO]:-Setting new master era
20200602:08:29:37:058354 gpstart:gpms:gpadmin-[INFO]:-Master Started...
20200602:08:29:37:058354 gpstart:gpms:gpadmin-[INFO]:-Shutting down master
20200602:08:29:39:058354 gpstart:gpms:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
....... 
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-Process results...
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-----------------------------------------------------
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-   Successful segment starts                                            = 12
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-----------------------------------------------------
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-Successfully started 12 of 12 segment instances 
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-----------------------------------------------------
20200602:08:29:46:058354 gpstart:gpms:gpadmin-[INFO]:-Starting Master instance gpms directory /home/gpadmin/gpdata/gpmaster/gpseg-1 
20200602:08:29:47:058354 gpstart:gpms:gpadmin-[INFO]:-Command pg_ctl reports Master gpms instance active
20200602:08:29:48:058354 gpstart:gpms:gpadmin-[INFO]:-No standby master configured.  skipping...
20200602:08:29:48:058354 gpstart:gpms:gpadmin-[INFO]:-Database successfully started
20200602:08:29:48:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20200602:08:29:48:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Starting initialization of standby master gps3
20200602:08:29:49:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20200602:08:29:51:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Checking for filespace directory /home/gpadmin/gpdata/gpmaster/gpseg-1 on gps3
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:------------------------------------------------------
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:------------------------------------------------------
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum master hostname               = gpms
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum master data directory         = /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum master port                   = 2345
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum standby master hostname       = gps3
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum standby master port           = 2345
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum standby master data directory = /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Greenplum update system catalog         = On
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:------------------------------------------------------
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:- Filespace locations
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:------------------------------------------------------
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-pg_system -> /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:29:52:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20200602:08:29:55:058488 gpinitstandby:gpms:gpadmin-[INFO]:-The packages on gps3 are consistent.
20200602:08:29:55:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Adding standby master to catalog...
20200602:08:29:55:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Database catalog updated successfully.
20200602:08:29:55:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Updating pg_hba.conf file...
20200602:08:30:02:058488 gpinitstandby:gpms:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20200602:08:30:07:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Updating filespace flat files...
20200602:08:30:07:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Filespace flat file updated successfully.
20200602:08:30:07:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Starting standby master
20200602:08:30:07:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Checking if standby master is running on host: gps3  in directory: /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:30:16:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20200602:08:30:18:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20200602:08:30:18:058488 gpinitstandby:gpms:gpadmin-[INFO]:-Successfully created standby master on gps3
20200602:08:30:18:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Successfully completed standby master initialization
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Log file scan check passed
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Greenplum Database instance successfully created
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-------------------------------------------------------
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-To complete the environment configuration, please 
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/home/gpadmin/gpdata/gpmaster/gpseg-1"
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-   or, use -d /home/gpadmin/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-   Example gpstate -d /home/gpadmin/gpdata/gpmaster/gpseg-1
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20200602.log
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Standby Master gps3 has been configured
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-failure review options for gpactivatestandby
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-------------------------------------------------------
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-The Master /home/gpadmin/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-new array must be explicitly added to this file
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-located in the /opt/greenplum/greenplum-db/./docs directory
20200602:08:30:19:051207 gpinitsystem:gpms:gpadmin-[INFO]:-------------------------------------------------------


附:gpinitsystem命令参考

[gpadmin@gps1 ~]$ gpinitsystem -h
      gpinitsystem -c gp_config_file [OPTIONS]
      Creates a new Greenplum Database instance on a Master host and a number of
      segment instance hosts.
      General options:
      -v, display version information & exit
      Logging options:
      -a, don't ask to confirm instance creation [default:- ask]
      -D, set log output to debug level, shows all function calls
      -l, logfile_directory [optional]
          Alternative logfile directory
      -q, quiet mode, do not log progress to screen [default:- verbose output to screen]
      Configuration options:
      -b, shared_buffers per instance [default 128000kB]
          Specify either the number of database I/O buffers (without suffix) or the
          amount of memory to use for buffers (with suffix 'kB', 'MB' or 'GB').
          Applies to master and all segments.
      -B, <number> run this batch of create segment processes in parallel [default 60]
      -c, gp_config_file [mandatory]
          Supplies all Greenplum configuration information required by this utility.
          Full description of all parameters contained within the example file
          supplied with this distribution.
          Also see gpinitsystem_INSTRUCTIONS file for greater detail on
          the operation and configuration of this script
      -e, <password>, password to set for Greenplum superuser in database [default gparray]
      -F, standby_filespaces [optiona]
      -h, gp_hostlist_file [optional]
          Contains a list of all segment instance hostnames required to participate in
          the new Greenplum instance. Normally set in gp_config_file.
      -I, <input_configuration_file>
          The full path and filename of an input configuration file, which defines the
          Greenplum Database members and segments using the QD_PRIMARY_ARRAY and
          PRIMARY_ARRAY parameters. The input configuration file is typically created by
          using gpinitsystem with the -O <output_configuration_file> option. You must
          provide either the -c <cluster_configuration_file> option or the -I
          <input_configuration_file> option to gpinitsystem.
      -m, maximum number of connections for master instance [default 250]
      -n, <locale>, setting for locale to be set when database initialized [default en_US.utf8]
      -O, <output_configuration_file>
          When used with the -O option, gpinitsystem does not create a new Greenplum
          Database cluster but instead writes the supplied cluster configuration
          information to the specified output_configuration_file. This file defines
          Greenplum Database members and segments using the QD_PRIMARY_ARRAY and
          PRIMARY_ARRAY parameters, and can be later used with -I
          <input_configuration_file> to initialize a new cluster.
      -p, postgresql_conf_gp_additions [optional]
          List of additional PostgreSQL parameters to be applied to each Master/Segment
          postgresql.conf file during Greenplum database initialization.
      -P, standby_port [optional]
      -s, standby_hostname [optional]
      -S, configure spread mirroring [default group]
      Return codes:
      0 - No problems encountered with requested operation
      1 - Warning generated, but instance operational
      2 - Fatal error, instance not created/started, or in an inconsistent state,
          see log file for failure reason.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29487349/viewspace-2695586/,如需转载,请注明出处,否则将追究法律责任。

全部评论
主要从事数据库相关工作,其他操作系统、中间件等也有涉及,热衷分享、开源,支持国产,期待中华民族全面的伟大复兴。岁月老将至,如有幸在江湖中留点踪迹,也是欣慰。 【文盲筱烨】好读书爱运动的IT技术爱好者 微博:文盲筱烨 微信公众号:筱烨视点

注册时间:2014-02-15

  • 博文量
    179
  • 访问量
    784457