Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the installation steps of greenplum4.3.33". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

2020.01.19

Check the log to report an error:

Pg_ctl error log:

FATAL: could not create semaphores: No space left on device

Modify

Vi / etc/sysctl.conf

Change the following behavior:

Kernel.sem = 50100 128256000 50100 2560

Modify the result:

[root@demo02 ~] # ipcs-ls

-Semaphore Limits-

Max number of arrays = 2560

Max semaphores per array = 50100

Max semaphores system wide = 128256000

Max ops per semop call = 50100

Semaphore max value = 32767

Process:

/ oradata/gp/gpdata/

Mkdir-p / oradata/gp/gpdata/gpdatam1

Mkdir-p / oradata/gp/gpdata/gpdatam2

Mkdir-p / oradata/gp/gpdata/gpdatap1

Mkdir-p / oradata/gp/gpdata/gpdatap2

Mkdir-p / oradata/gp/gpdata/gpmaster

Gpssh-f / home/gpadmin/conf/hostlist

/ oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config

Gpinitsystem-c / oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config-h / home/gpadmin/conf/hostlist

[gpadmin@demo02 gpdata] $gpinitsystem-c / oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config-h / home/gpadmin/conf/hostlist

20200119 Checking configuration parameters 22 56 gpinitsystem:demo02:gpadmin- 18 022378 [INFO]:-Checking configuration parameters, please wait...

20200119 Reading Greenplum configuration file 22 56 gpinitsystem:demo02:gpadmin- 18 022378 [INFO]:-Reading Greenplum configuration file / oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config

20200119 oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config 22 56 gpinitsystem:demo02:gpadmin- 18 022378 [INFO]:-Locale has not been set in / oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config, will set to default value

20200119 Locale set to en_US.utf8 22 56 gpinitsystem:demo02:gpadmin- 18 22378 [INFO]:-Locale set to en_US.utf8

20200119 No DATABASE_NAME set 22 56 will exit following template1 updates 19 022378 gpinitsystem:demo02:gpadmin- [INFO]:-No DATABASE_NAME set, will exit following template1 updates

20200119 ENCODING variable not set 22 56 will set to default UTF-8 19 022378 gpinitsystem:demo02:gpadmin- [WARN]:-ENCODING variable not set, will set to default UTF-8

20200119 MASTER_MAX_CONNECT not set 22 56 will set to default value 19 022378 gpinitsystem:demo02:gpadmin- [INFO]:-MASTER_MAX_CONNECT not set

20200119 Checking configuration parameters 22 56 Completed 19 022378 gpinitsystem:demo02:gpadmin- [INFO]:-Checking configuration parameters, Completed

20200119 Commencing multi-home checks 22 56 please wait... 19 022378 gpinitsystem:demo02:gpadmin- [INFO]:-Commencing multi-home checks, please wait...

..

20200119 Configuring build for standard array 2226 gpinitsystem:demo02:gpadmin- 022378:-Configuring build for standard array

022378 gpinitsystem:demo02:gpadmin- [INFO]:-Commencing multi-home checks, Completed

022378 gpinitsystem:demo02:gpadmin- [INFO]:-Building primary segment instance array, please wait...

....

20200119 22 57 gpinitsystem:demo02:gpadmin- 0622 378 gpinitsystem:demo02:gpadmin- [INFO]:-Building group mirror array type, please wait...

....

20200119 gpinitsystem:demo02:gpadmin- 2257 Checking Master host 29022378 [INFO]:-Checking Master host

20200119 Checking new segment hosts 22 57 please wait... 29 22 378 gpinitsystem:demo02:gpadmin- [INFO]:-Checking new segment hosts, please wait...

.

20200119 Checking new segment hosts 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Checking new segment hosts, Completed

20200119 Greenplum Database Creation Parameters 23 02 gpinitsystem:demo02:gpadmin- 1515 22 378 [INFO]:-Greenplum Database Creation Parameters

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 Master Configuration 23 02 gpinitsystem:demo02:gpadmin- 1515 22 378 [INFO]:-Master Configuration

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 Master instance name 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master instance name = Greenplum

20200119 Master hostname 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master hostname = demo02

20200119 Master port 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master port = 2345

20200119 Master instance dir 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master instance dir = / oradata/gp/gpdata/gpmaster/gpseg-1

20200119 Master LOCALE 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master LOCALE = en_US.utf8

20200119 Greenplum segment prefix 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Greenplum segment prefix = gpseg

20200119 Master Database 23 0215 gpinitsystem:demo02:gpadmin- [INFO]:-Master Database =

20200119 Master connections 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master connections = 250

20200119 Master buffers 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master buffers = 128000kB

20200119 Segment connections 23 0215 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Segment connections = 750

20200119 Segment buffers 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Segment buffers = 128000kB

20200119 Checkpoint segments 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Checkpoint segments = 8

20200119 Encoding 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Encoding = UTF-8

20200119 Postgres param file 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Postgres param file = Off

20200119 Initdb to be used 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Initdb to be used = / oradata/gp/greenplum-db/./bin/initdb

20200119 GP_LIBRARY_PATH is 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-GP_LIBRARY_PATH is = / oradata/gp/greenplum-db/./lib

20200119 Ulimit check 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Ulimit check = Passed

20200119 Array host connect type 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Array host connect type = Single hostname per node

20200119 Master IP address 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master IP address [1] =:: 1

20200119 Master IP address 23 0215 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Master IP address [2] = 10.138.231.201

20200119 Master IP address 23 0215 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Master IP address [3] = 172.32.16.2

20200119 Master IP address 23 0215 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Master IP address [4] = 172.32.32.2

20200119 Master IP address 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master IP address [5] = fe80::250:56ff:fe8c:20d2

20200119 Master IP address 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master IP address [6] = fe80::250:56ff:fe8c:2375

20200119 Master IP address 23 02 15 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Master IP address [7] = fe80::250:56ff:fe8c:a091

20200119 Master IP address 23 02 15 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Master IP address [8] = fe80::250:56ff:fe8c:c81

20200119 Master IP address 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Master IP address [9] = fe80::250:56ff:fe8c:d584

20200119 Standby Master 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Standby Master = Not Configured

20200119 Primary segment 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Primary segment # = 2

20200119 Total Database segments 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Total Database segments = 4

20200119 Trusted shell 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Trusted shell = ssh

20200119 Number segment hosts 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Number segment hosts = 2

20200119 Mirror port base 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Mirror port base = 43000

20200119 Replicaton port base 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Replicaton port base = 34000

20200119 Mirror replicaton port base= 23 02 gpinitsystem:demo02:gpadmin- 1515 022378 [INFO]:-Mirror replicaton port base= 44000

20200119 Mirror segment 23 02 gpinitsystem:demo02:gpadmin- 1522 378 [INFO]:-Mirror segment # = 2

20200119 Mirroring config 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Mirroring config = ON

20200119 Mirroring type 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-Mirroring type = Group

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 Greenplum Primary Segment Configuration 23 02 gpinitsystem:demo02:gpadmin- 1515 22 378 [INFO]:-Greenplum Primary Segment Configuration

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 oradata/gp/gpdata/gpdatap1/gpseg0 23 02 gpinitsystem:demo02:gpadmin- [INFO]:-demo02 / oradata/gp/gpdata/gpdatap1/gpseg0 33000 20 34000

20200119 demo02 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-demo02 / oradata/gp/gpdata/gpdatap2/gpseg1 33001 3 1 34001

20200119 oradata/gp/gpdata/gpdatap1/gpseg2 23 02 gpinitsystem:demo02:gpadmin- [INFO]:-demo01 / oradata/gp/gpdata/gpdatap1/gpseg2 33000 4 2 34000

20200119 demo01 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-demo01 / oradata/gp/gpdata/gpdatap2/gpseg3 33001 5 3 34001

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 Greenplum Mirror Segment Configuration 23 02 gpinitsystem:demo02:gpadmin- 1515 22 378 [INFO]:-Greenplum Mirror Segment Configuration

20200119 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-

20200119 oradata/gp/gpdata/gpdatam1/gpseg0 23 02 gpinitsystem:demo02:gpadmin- [INFO]:-demo01 / oradata/gp/gpdata/gpdatam1/gpseg0 43000 6 0 44000

20200119 oradata/gp/gpdata/gpdatam2/gpseg1 23 02 gpinitsystem:demo02:gpadmin- [INFO]:-demo01 / oradata/gp/gpdata/gpdatam2/gpseg1 43001 7 1 44001

20200119 oradata/gp/gpdata/gpdatam1/gpseg2 23 02 gpinitsystem:demo02:gpadmin- [INFO]:-demo02 / oradata/gp/gpdata/gpdatam1/gpseg2 43000 8 2 44000

20200119 oradata/gp/gpdata/gpdatam2/gpseg3 23 02 gpinitsystem:demo02:gpadmin- 15 22 378 [INFO]:-demo02 / oradata/gp/gpdata/gpdatam2/gpseg3 43001 9 3 44001

Continue with Greenplum creation Yy/Nn >

Y

20200119 Building the Master instance database 23 03 gpinitsystem:demo02:gpadmin- 32 Building the Master instance database [INFO]:-Building the Master instance database, please wait...

20200119 Starting the Master in admin mode 23 03 gpinitsystem:demo02:gpadmin- 022378:-Starting the Master in admin mode

20200119 Commencing parallel build of primary segment instances 23 04 gpinitsystem:demo02:gpadmin- 022378:-Commencing parallel build of primary segment instances

20200119 Spawning parallel processes batch 23 04 gpinitsystem:demo02:gpadmin- 45 22 378 [INFO]:-Spawning parallel processes batch [1], please wait...

....

20200119 Waiting for parallel processes batch 23 04 gpinitsystem:demo02:gpadmin- 45 22 378 [INFO]:-Waiting for parallel processes batch [1], please wait...

. . . . ...

022378 gpinitsystem:demo02:gpadmin- [INFO]:

20200119 Parallel process exit status 23 13 40 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-

022378 gpinitsystem:demo02:gpadmin- [INFO]:

20200119 Total processes marked as completed 23 13 40 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Total processes marked as completed = 4

20200119 Total processes marked as killed 23 13 40 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Total processes marked as killed = 0

20200119 Total processes marked as failed 23 13 40 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Total processes marked as failed = 0

022378 gpinitsystem:demo02:gpadmin- [INFO]:

20200119 Commencing parallel build of mirror segment instances 23 13 40 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-

20200119 Spawning parallel processes batch 23 1340 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Spawning parallel processes batch [1], please wait...

....

20200119 Waiting for parallel processes batch 23 1340 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Waiting for parallel processes batch [1], please wait...

. . . . ..

20200119 23 22 14 21 14 022378 gpinitsystem:demo02:gpadmin- [INFO]:-

20200119 Parallel process exit status 23 22 Parallel process exit status 21 14 022378 gpinitsystem:demo02:gpadmin- [Parallel process exit status]:

20200119 23 22 14 21 14 022378 gpinitsystem:demo02:gpadmin- [INFO]:-

20200119 Total processes marked as completed 23 22 Total processes marked as completed 21 022378 gpinitsystem:demo02:gpadmin- [INFO]:-Total processes marked as completed = 4

20200119 Total processes marked as killed 23 22 Total processes marked as killed 21 022378 gpinitsystem:demo02:gpadmin- [INFO]:-Total processes marked as killed = 0

20200119 Total processes marked as failed 23 22 Total processes marked as failed 21 022378 gpinitsystem:demo02:gpadmin- [INFO]:-Total processes marked as failed = 0

20200119 23 22 14 21 14 022378 gpinitsystem:demo02:gpadmin- [INFO]:-

20200119 Deleting distributed backout files 23 22 Deleting distributed backout files 21 14 022378 gpinitsystem:demo02:gpadmin- [Deleting distributed backout files]:

20200119 Removing back out file 23 22 Removing back out file 21 14 022378 gpinitsystem:demo02:gpadmin- [Removing back out file]:

20200119 No errors generated from parallel processes 23 22 No errors generated from parallel processes 21 14 022378 gpinitsystem:demo02:gpadmin- [No errors generated from parallel processes]:

20200119 Restarting the Greenplum instance in production mode 23 22 Restarting the Greenplum instance in production mode 21 14 022378 gpinitsystem:demo02:gpadmin- [Restarting the Greenplum instance in production mode]:

20200119 Starting gpstop with args 23 22 gpstop:demo02:gpadmin- 22 004847 [INFO]:-Starting gpstop with args:-a-l / home/gpadmin/gpAdminLogs-I-m-d / oradata/gp/gpdata/gpmaster/gpseg-1

20200119 Gathering information and validating the environment... 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Obtaining Greenplum Master catalog information 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Obtaining Segment details from master... 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Greenplum Version 23 22 Greenplum Version 23 22 15 004847 gpstop:demo02:gpadmin- [INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.33.4 build 1'

20200119 There are 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-There are 0 connections to the database

20200119 Commencing Master instance shutdown with mode='immediate' 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Master host=demo02 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Commencing Master instance shutdown with mode=immediate 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Master segment instance directory=/oradata/gp/gpdata/gpmaster/gpseg-1 23 22 14 14 004847 gpstop:demo02:gpadmin- [INFO]:-

20200119 Attempting forceful termination of any leftover master process 23 22 22 14 004847 gpstop:demo02:gpadmin- [INFO]:-Attempting forceful termination of any leftover master process

20200119 Terminating processes for segment 23 22 Terminating processes for segment 23 004847 gpstop:demo02:gpadmin- [INFO]:-Terminating processes for segment

INFO:-Starting gpstart with args:-a-l / home/gpadmin/gpAdminLogs-d / oradata/gp/gpdata/gpmaster/gpseg-1

20200119 gpstart:demo02:gpadmin- 23 22 22 14 00 4874 gpstart:demo02:gpadmin- [INFO]:-Gathering information and validating the environment...

20200119 Greenplum Binary Version Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.33.4 build 1'

20200119 Greenplum Catalog Version 23 22 22 14 004874 gpstart:demo02:gpadmin- [INFO]:-Greenplum Catalog Version: '201310150'

20200119 gpstart:demo02:gpadmin- 23 22 22 14 00 4874 gpstart:demo02:gpadmin- [INFO]:-Starting Master instance in admin mode

20200119 Obtaining Greenplum Master catalog information 23 2214 24 gpstart:demo02:gpadmin- 004874 [INFO]:-Obtaining Greenplum Master catalog information

20200119 Obtaining Segment details from master... 23 2214 24 gpstart:demo02:gpadmin- 004874 [INFO]:-Obtaining Segment details from master...

20200119 Setting new master era 23 2214 24 gpstart:demo02:gpadmin- 004874 [INFO]:-Setting new master era

20200119 Master Started... 23 2214 24 gpstart:demo02:gpadmin- 004874 [INFO]:-Master Started...

20200119 Shutting down master 23 2214 24 gpstart:demo02:gpadmin- 004874 [INFO]:-Shutting down master

20200119 Commencing parallel primary and mirror segment instance startup 23 22 22 26 14 004874 gpstart:demo02:gpadmin- [INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...

.

20200119 Process results... 23 22 14 42 gpstart:demo02:gpadmin- [INFO]:-Process results...

20200119 23 22 14 42 14 004874 gpstart:demo02:gpadmin- [INFO]:

20200119 Successful segment starts 23 22 22 14 42 gpstart:demo02:gpadmin- 004874 [INFO]:-Successful segment starts = 8

20200119 Failed segment starts 23 22 22 14 42 gpstart:demo02:gpadmin- 004874 [INFO]:-Failed segment starts = 0

20200119 Skipped segment starts 23 22 22 22 4 048 74 gpstart:demo02:gpadmin- [INFO]:-Skipped segment starts (segments are marked down in configuration) = 0

20200119 23 22 14 42 14 004874 gpstart:demo02:gpadmin- [INFO]:

20200119 23 22 22 4215 004874 gpstart:demo02:gpadmin- [INFO]:-

20200119 of 23 22 Successfully started 4215 004874 gpstart:demo02:gpadmin- [INFO]:-Successfully started 8 of 8 segment instances

20200119 23 22 14 42 14 004874 gpstart:demo02:gpadmin- [INFO]:

20200119 Starting Master instance demo02 directory 23 22 Starting Master instance demo02 directory 4215 004874 gpstart:demo02:gpadmin- [INFO]:-Starting Master instance demo02 directory / oradata/gp/gpdata/gpmaster/gpseg-1

20200119 Command pg_ctl reports Master demo02 instance active 23 22 14 43 00 4874 gpstart:demo02:gpadmin- [INFO]:-Command pg_ctl reports Master demo02 instance active

20200119 No standby master configured 23 22 14 43 00 4874 gpstart:demo02:gpadmin- [INFO]:-No standby master configured. Skipping...

20200119 Database successfully started 23 22 14 43 00 4874 gpstart:demo02:gpadmin- [INFO]:-Database successfully started

20200119 Completed restart of Greenplum instance in production mode 23 2214 46 Completed restart of Greenplum instance in production mode 022378 gpinitsystem:demo02:gpadmin- [INFO]:

20200119 Loading gp_toolkit... 23 2214 46 Loading gp_toolkit... 022378 gpinitsystem:demo02:gpadmin- [INFO]:

20200119 Scanning utility log file for any warning messages 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Scanning utility log file for any warning messages

20200119 23 22 14 47 gpinitsystem:demo02:gpadmin- [WARN]:-*

20200119 Scan of log file indicates that some warnings or errors 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [WARN]:-Scan of log file indicates that some warnings or errors

20200119 were generated during the array creation 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [WARN]:-were generated during the array creation

20200119 Please review contents of log file 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Please review contents of log file

20200119 home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-/ home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log

20200119 To determine level of criticality 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-To determine level of criticality

20200119 These messages could be from a previous run of the utility 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-These messages could be from a previous run of the utility

022378 gpinitsystem:demo02:gpadmin- [INFO]:-that was called today!

20200119 23 22 14 47 gpinitsystem:demo02:gpadmin- [WARN]:-*

20200119 Greenplum Database instance successfully created 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Greenplum Database instance successfully created

022378 gpinitsystem:demo02:gpadmin- [INFO]:

022378 gpinitsystem:demo02:gpadmin- [INFO]:-To complete the environment configuration, please

022378 gpinitsystem:demo02:gpadmin- [INFO]:-update gpadmin .bashrc file with the following

022378 gpinitsystem:demo02:gpadmin- [INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20200119 23 22 14 47 14 022378 gpinitsystem:demo02:gpadmin- [INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/oradata/gp/gpdata/gpmaster/gpseg-1"

20200119 to access the Greenplum scripts for this instance 23 22 14 47 to access the Greenplum scripts for this instance 022378 gpinitsystem:demo02:gpadmin- [to access the Greenplum scripts for this instance]:

022378 gpinitsystem:demo02:gpadmin- [INFO]:-or, use-d / oradata/gp/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts

022378 gpinitsystem:demo02:gpadmin- [INFO]:-Example gpstate-d / oradata/gp/gpdata/gpmaster/gpseg-1

20200119 Script log file 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Script log file = / home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log

022378 gpinitsystem:demo02:gpadmin- [INFO]:-To remove instance, run gpdeletesystem utility

20200119 To initialize a Standby Master Segment for this Greenplum instance 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-To initialize a Standby Master Segment for this Greenplum instance

20200119 Review options for gpinitstandby 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Review options for gpinitstandby

022378 gpinitsystem:demo02:gpadmin- [INFO]:

022378 gpinitsystem:demo02:gpadmin- [INFO]:-The Master / oradata/gp/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem

20200119 has been configured to allow all hosts within this new 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-has been configured to allow all hosts within this new

022378 gpinitsystem:demo02:gpadmin- [INFO]:-array to intercommunicate. Any hosts external to this

20200119 new array must be explicitly added to this file 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-new array must be explicitly added to this file

20200119 Refer to the Greenplum Admin support guide which is 23 22 14 47 gpinitsystem:demo02:gpadmin- 022378 [INFO]:-Refer to the Greenplum Admin support guide which is

022378 gpinitsystem:demo02:gpadmin- [INFO]:-located in the / oradata/gp/greenplum-db/./docs directory

022378 gpinitsystem:demo02:gpadmin- [INFO]:

After initialization is complete:

[gpadmin@demo02 gpseg-1] $psql-h 10.138.231.201-d postgres-p 2345

This is the end of the content of "greenplum4.3.33 installation steps". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.