GreenPlum 4.3集群安装（三）

GreenPlum 4.3 SUSE集群安装手册

9.0.3 初始化数据库

操作步骤

                                步骤 1     在master主机上gpadmin用户登录数据库服务器；

su - gpadmin

                                步骤 1     执行gpinitsystem操作，如下：

gpadmin@linux-82:~> source /usr/local/greenplum-db/greenplum_path.sh

gpadmin@linux-82:~> gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem

执行信息如下：

20140416:14:30:29:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Reading Greenplum configuration file gpconfigs/gpinitsystem_config

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Locale has not been set in gpconfigs/gpinitsystem_config, will set to default value

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Locale set to en_US.utf8

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checking configuration parameters, Completed

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

.

20140416:14:30:30:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Configuring build for standard array

20140416:14:30:31:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20140416:14:30:31:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Building primary segment instance array, please wait...

..

20140416:14:30:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Building group mirror array type , please wait...

..

20140416:14:30:33:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checking Master host

20140416:14:30:33:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checking new segment hosts, please wait...

....

20140416:14:30:37:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checking new segment hosts, Completed

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Greenplum Database Creation Parameters

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:---------------------------------------

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master Configuration

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:---------------------------------------

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master instance name       = EMC Greenplum DW

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master hostname            = linux-82

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master port                = 5432

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master instance dir        = /opt/greenplum/master/gpseg-1

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master Database            =

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master connections         = 250

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master buffers             = 128000kB

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Segment connections        = 750

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Segment buffers            = 128000kB

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Checkpoint segments        = 8

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Encoding                   = UNICODE

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Postgres param file        = Off

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db/bin/initdb

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db/lib

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Ulimit check               = Passed

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Array host connect type    = Single hostname per node

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master IP address [1]      = ::1

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master IP address [2]      = 10.41.28.82

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Master IP address [3]      = fe80::5ef3:fcff:fedc:e2a

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Standby Master             = Not Configured

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Primary segment #          = 2

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total Database segments    = 2

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Trusted shell              = ssh

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Number segment hosts       = 1

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Mirror port base           = 50000

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Replicaton port base       = 41000

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Mirror replicaton port base= 51000

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Mirror segment #           = 2

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Mirroring config           = ON

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Mirroring type             = Group

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:----------------------------------------

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:----------------------------------------

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-linux-84         /opt/greenplum/primary/gpseg0   40000   2       0       41000

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-linux-84         /opt/greenplum/primary/gpseg1   40001   3       1       41001

20140416:14:30:38:028973 gpinitsystem:linux-82:gpadmin-[INFO]:---------------------------------------

20140416:14:30:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration

20140416:14:30:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:---------------------------------------

20140416:14:30:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-linux-84         /opt/greenplum/mirror/gpseg0    50000   4       0       51000

20140416:14:30:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-linux-84         /opt/greenplum/mirror/gpseg1    50001   5       1       51001

Continue with Greenplum creation Yy/Nn>

入力：y

20140416:14:30:42:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Building the Master instance database, please wait...

20140416:14:31:00:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Starting the Master in admin mode

20140416:14:31:07:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Commencing parallel build of primary segment instances

20140416:14:31:07:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

..

20140416:14:31:07:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

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

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Parallel process exit status

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as completed           = 2

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as killed              = 0

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as failed              = 0

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

..

20140416:14:31:32:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

.......

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Parallel process exit status

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as completed           = 2

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as killed              = 0

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Total processes marked as failed              = 0

20140416:14:31:39:028973 gpinitsystem:linux-82:gpadmin-[INFO]:------------------------------------------------

20140416:14:31:40:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Deleting distributed backout files

20140416:14:31:40:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Removing back out file

20140416:14:31:40:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-No errors generated from parallel processes

20140416:14:31:40:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /opt/greenplum/master/gpseg-1

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Gathering information and validating the environment...

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Obtaining Segment details from master...

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.0.0POC3 build 45206'

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-There are 0 connections to the database

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Master host=linux-82

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate

20140416:14:31:40:046227 gpstop:linux-82:gpadmin-[INFO]:-Master segment instance directory=/opt/greenplum/master/gpseg-1

20140416:14:31:42:046311 gpstart:linux-82:gpadmin-[INFO]:-Starting gpstart with args: -a -d /opt/greenplum/master/gpseg-1

20140416:14:31:42:046311 gpstart:linux-82:gpadmin-[INFO]:-Gathering information and validating the environment...

20140416:14:31:42:046311 gpstart:linux-82:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.0.0POC3 build 45206'

20140416:14:31:42:046311 gpstart:linux-82:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'

20140416:14:31:42:046311 gpstart:linux-82:gpadmin-[INFO]:-Starting Master instance in admin mode

20140416:14:31:43:046311 gpstart:linux-82:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20140416:14:31:43:046311 gpstart:linux-82:gpadmin-[INFO]:-Obtaining Segment details from master...

20140416:14:31:43:046311 gpstart:linux-82:gpadmin-[INFO]:-Setting new master era

20140416:14:31:43:046311 gpstart:linux-82:gpadmin-[INFO]:-Master Started...

20140416:14:31:43:046311 gpstart:linux-82:gpadmin-[INFO]:-Shutting down master

20140416:14:31:45:046311 gpstart:linux-82:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...

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

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-Process results...

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-----------------------------------------------------

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-   Successful segment starts                                            = 4

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-   Failed segment starts                                                = 0

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-----------------------------------------------------

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-----------------------------------------------------

20140416:14:32:01:046311 gpstart:linux-82:gpadmin-[INFO]:-Starting Master instance linux-82 directory /opt/greenplum/master/gpseg-1

20140416:14:32:02:046311 gpstart:linux-82:gpadmin-[INFO]:-Command pg_ctl reports Master linux-82 instance active

20140416:14:32:02:046311 gpstart:linux-82:gpadmin-[INFO]:-No standby master configured.  skipping...

20140416:14:32:02:046311 gpstart:linux-82:gpadmin-[INFO]:-Database successfully started

20140416:14:32:02:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode

20140416:14:32:02:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Loading gp_toolkit...

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Scanning utility log file for any warning messages

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[WARN]:-*******************************************************

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[WARN]:-were generated during the array creation

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Please review contents of log file

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20140416.log

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-To determine level of criticality

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-These messages could be from a previous run of the utility

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-that was called today!

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[WARN]:-*******************************************************

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Greenplum Database instance successfully created

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-------------------------------------------------------

20140416:14:32:04:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-To complete the environment configuration, please

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-update gpadmin .bashrc file with the following

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/opt/greenplum/master/gpseg-1"

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-   or, use -d /opt/greenplum/master/gpseg-1 option for the Greenplum scripts

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-   Example gpstate -d /opt/greenplum/master/gpseg-1

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20140416.log

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Review options for gpinitstandby

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-------------------------------------------------------

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-The Master /opt/greenplum/master/gpseg-1/pg_hba.conf post gpinitsystem

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-has been configured to allow all hosts within this new

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-new array must be explicitly added to this file

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/docs directory

20140416:14:32:05:028973 gpinitsystem:linux-82:gpadmin-[INFO]:-------------------------------------------------------

 

9.0.4 设置环境变量

操作步骤

                                步骤 1     在master主机上gpadmin用户登录数据库服务器；

su - gpadmin

                                步骤 2     打开.bashrc 配置文件，操作如下：

gpadmin@linux-82:~> vi .bashrc

编辑添加的内容如下：

source /usr/local/greenplum-db/greenplum_path.sh

export MASTER_DATA_DIRECTORY=/opt/greenplum/master/gpseg-1

export PGPORT=5432

export PGUSER=gpadmin

 

                                步骤 3     保存并激活配置文件，如下：

gpadmin@linux-82:~> source .bashrc

 

NOTE：当装有备用master主机的场合，需拷贝master主机上的环境配置文件到备用机上，此时执行如下操作：

$ cd ~

$ scp .bashrc standby_hostname:`pwd`

 

         至此，SUSE上的GreenPlum集群安装成功。