greenplum4.3.33的安装步骤-创新互联

本篇内容介绍了“greenplum4.3.33的安装步骤”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

2020.01.19

查看日志报错：

pg_ctl报错日志：

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

修改

vi /etc/sysctl.conf

更改如下行为：

kernel.sem = 50100 128256000 50100 2560

修改结果：

[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

处理过程：

/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:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking configuration parameters, please wait...

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

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

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

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

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

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

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

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

..

20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Configuring build for standard array

20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing multi-home checks, Completed

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

....

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

....

20200119:22:57:29:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking Master host

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

........

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Database Creation Parameters

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Configuration

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

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

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

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

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

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

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Database            = 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02     /oradata/gp/gpdata/gpdatap1/gpseg0      33000   2       0       34000

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

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

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

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

20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration

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

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

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

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

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

Continue with Greenplum creation Yy/Nn>

y

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

20200119:23:03:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Starting the Master in admin mode

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

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

....

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

..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------

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

20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------

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

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

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

20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------

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

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

....

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

.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

20200119:23:22:23:004847 gpstop:demo02:gpadmin-[INFO]:-Terminating processes for segment /oradata/gp/gpdata/gpmaster/gpseg-1

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

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

20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.33.4 build 1'

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

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

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

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

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

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

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

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

................ 

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

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

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

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

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

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

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

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

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

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

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

20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-No standby master configured.  skipping...

20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-Database successfully started

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

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

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

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

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

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

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

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

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

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

20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-that was called today!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

初始化完成后：

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

“greenplum4.3.33的安装步骤”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联-成都网站建设公司网站，小编将为大家输出更多高质量的实用文章！