【greenplum】greenplum叢集資料庫初始化輸出內容樣例
--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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【greenplum】greenplum叢集搭建
- GreenPlum資料庫安裝資料庫
- 安裝Greenplum 5.2 叢集實戰
- Greenplum初始化資料庫gpinitsystem報錯以及解決資料庫
- Greenplum資料庫,分散式資料庫,大資料資料庫分散式大資料
- Greenplum資料庫系統架構資料庫架構
- greenplum 6.9 for centos7叢集搭建步驟CentOS
- Greenplum資料庫的dblink功能之搭建資料庫
- oracle 跨庫查詢greenplum慢Oracle
- 4 管理資料庫例項和叢集資料庫資料庫
- 【PG】mysql時時同步資料至greenplumMySql
- 海量資料處理利器greenplum——初識
- Greenplum gp_vmem_protect_limit 出錯MIT
- 如何把資料從Mysql匯入到GreenplumMySql
- AWSredshift->hdbpg(Greenplum),資料庫-S3匯入匯出(unload,externaltable)-hdbpgexternaltable資料庫S3
- Mysql同步到GreenplumMySql
- Greenplum介紹-PartitionedTable
- greenplum安裝部署
- GreenPlum DBA常用SQLSQL
- 資料庫叢集資料庫
- 【GP】greenplum監控軟體Greenplum-cc-web的安裝Web
- greenplum使用gpfdist與外部表高效匯入資料
- mpp 資料庫greenplum官方商業版本與開源版本的差異資料庫
- ETL資料整合丨將GreenPlum資料同步至Doris數倉
- greenplum 4.3.33安裝
- greenplum擴充套件segment套件
- PostgreSQL 技術內幕(五)Greenplum-Interconnect模組SQL
- MySQL資料庫叢集MySql資料庫
- 基於Greenplum,postgreSQL的大型資料倉儲實踐SQL
- Greenplum,PostgreSQL資料實時訂閱的幾種方式SQL
- Greenplum海量資料,大寬錶行存VS列存
- GreenPlum儲存過程的原始碼匯出儲存過程原始碼
- 直播|PostgreSQL 技術內幕(五)Greenplum-Interconnect模組SQL
- 用 gpss 從 kafka 消費資料載入到 greenplumKafka
- 《Greenplum構建實時資料倉儲實踐》簡介
- greenplum單節點安裝
- 聊一聊Greenplum與PostgreSQLSQL
- Greenplum安裝dblink模組