greenplum4.2安装配置文档-手把手…

来源：互联网发布：电影台词拼接软件编辑：程序博客网时间：2024/06/16 01:11

1 初始化数据库

Gpadmin用户执行

1.1 初始化

gpinitsystem -c/home/gpadmin/gpinitsystem_config

完成过程如下：

[gpadmin@gpmaster ~]$ gpinitsystem -c/home/gpadmin/gpinitsystem_config

20130815:21:36:03:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checking configurationparameters, please wait...

/bin/mv: overwrite `/home/gpadmin/gpinitsystem_config',overriding mode 0444?

20130815:21:36:17:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Reading Greenplumconfiguration file /home/gpadmin/gpinitsystem_config

20130815:21:36:17:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Locale has not been set in/home/gpadmin/gpinitsystem_config, will set to defaultvalue

20130815:21:36:21:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Locale set toen_US.utf8

20130815:21:36:27:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set,will set to default value 250

20130815:21:36:31:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checking configurationparameters, Completed

20130815:21:36:32:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Commencing multi-home checks,please wait...

20130815:21:36:45:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Configuring build forstandard array

20130815:21:36:45:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Commencing multi-home checks,Completed

20130815:21:36:47:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Building primary segmentinstance array, please wait...

20130815:21:36:59:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checking Masterhost

20130815:21:37:02:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checking new segment hosts,please wait...

20130815:21:37:47:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checking new segment hosts,Completed

20130815:21:37:49:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Greenplum Database CreationParameters

20130815:21:37:50:003699gpinitsystem:gpmaster:gpadmin-[INFO]:---------------------------------------

20130815:21:37:51:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-MasterConfiguration

20130815:21:37:51:003699gpinitsystem:gpmaster:gpadmin-[INFO]:---------------------------------------

20130815:21:37:52:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master instancename = LJG Greenplum DW

20130815:21:37:52:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master hostname = gpmaster

20130815:21:37:53:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master port = 5432

20130815:21:37:53:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master instancedir = /data/master/gpseg-1

20130815:21:37:54:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master LOCALE =en_US.utf8

20130815:21:37:54:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Greenplum segmentprefix =gpseg

20130815:21:37:55:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master Database = gpsun

20130815:21:37:56:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Masterconnections = 250

20130815:21:37:56:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master buffers = 128000kB

20130815:21:37:57:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Segmentconnections = 750

20130815:21:37:57:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Segment buffers = 128000kB

20130815:21:37:58:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Checkpointsegments = 8

20130815:21:37:59:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Encoding = UNICODE

20130815:21:37:59:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Postgres paramfile = Off

20130815:21:38:00:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb

20130815:21:38:00:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-GP_LIBRARY_PATHis = /usr/local/greenplum-db/./lib

20130815:21:38:01:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Ulimit check = Passed

20130815:21:38:02:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Array host connecttype = Single hostname per node

20130815:21:38:02:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[1] = ::1

20130815:21:38:03:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[2] = 192.168.122.1

20130815:21:38:03:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[3] = 192.168.66.110

20130815:21:38:04:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[4] = fe80::200:ff:fe00:0

20130815:21:38:05:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[5] = fe80::20c:29ff:fe7e:b8a2

20130815:21:38:05:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Master IP address[6] = fe80::fcff:ffff:feff:ffff

20130815:21:38:06:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Standby Master = Not Configured

20130815:21:38:06:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Primary segment # = 1

20130815:21:38:07:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Total Databasesegments = 2

20130815:21:38:07:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Trusted shell = ssh

20130815:21:38:08:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Number segmenthosts = 2

20130815:21:38:08:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Mirroring config = OFF

20130815:21:38:09:003699gpinitsystem:gpmaster:gpadmin-[INFO]:----------------------------------------

20130815:21:38:10:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Greenplum Primary SegmentConfiguration

20130815:21:38:10:003699gpinitsystem:gpmaster:gpadmin-[INFO]:----------------------------------------

20130815:21:38:11:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-gpnode1 /data/data1/data/gpseg0 40000 2 0

20130815:21:38:11:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-gpnode2 /data/data1/data/gpseg1 40000 3 1

Continue with Greenplum creationYy/Nn>

20130815:21:38:18:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Building the Master instancedatabase, please wait...

20130815:21:41:27:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Starting the Master in adminmode

20130815:21:42:29:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Commencing parallel build ofprimary segment instances

20130815:21:42:30:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Spawning parallelprocesses batch [1], please wait...

20130815:21:42:35:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Waiting for parallelprocesses batch [1], please wait...

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

20130815:21:47:52:003699gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------

20130815:21:47:53:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Parallel process exitstatus

20130815:21:47:53:003699gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------

20130815:21:47:54:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked ascompleted = 2

20130815:21:47:54:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked askilled = 0

20130815:21:47:54:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Total processes marked asfailed = 0

20130815:21:47:55:003699gpinitsystem:gpmaster:gpadmin-[INFO]:------------------------------------------------

20130815:21:47:56:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Deleting distributed backoutfiles

20130815:21:47:57:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Removing back outfile

20130815:21:47:57:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-No errors generated fromparallel processes

20130815:21:47:59:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Restarting the Greenpluminstance in production mode

20130815:21:48:00:015501gpstop:gpmaster:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m-d /data/master/gpseg-1

20130815:21:48:00:015501gpstop:gpmaster:gpadmin-[INFO]:-Gathering information andvalidating the environment...

20130815:21:48:00:015501gpstop:gpmaster:gpadmin-[INFO]:-Obtaining Greenplum Master cataloginformation

20130815:21:48:00:015501gpstop:gpmaster:gpadmin-[INFO]:-Obtaining Segment details frommaster...

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-Greenplum Version: 'postgres(Greenplum Database) 4.2.2.4 build 1 Community Edition'

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-There are 0 connections to thedatabase

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-Commencing Master instance shutdownwith mode='immediate'

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-Master host=gpmaster

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-Commencing Master instance shutdownwith mode=immediate

20130815:21:48:03:015501gpstop:gpmaster:gpadmin-[INFO]:-Master segment instancedirectory=/data/master/gpseg-1

20130815:21:48:08:015584gpstart:gpmaster:gpadmin-[INFO]:-Starting gpstart with args: -a -d/data/master/gpseg-1

20130815:21:48:08:015584gpstart:gpmaster:gpadmin-[INFO]:-Gathering information andvalidating the environment...

20130815:21:48:09:015584gpstart:gpmaster:gpadmin-[INFO]:-Greenplum Binary Version:'postgres (Greenplum Database) 4.2.2.4 build 1 CommunityEdition'

20130815:21:48:11:015584gpstart:gpmaster:gpadmin-[INFO]:-Greenplum Catalog Version:'201109210'

20130815:21:48:13:015584gpstart:gpmaster:gpadmin-[INFO]:-Starting Master instance in adminmode

20130815:21:48:18:015584gpstart:gpmaster:gpadmin-[INFO]:-Obtaining Greenplum Master cataloginformation

20130815:21:48:18:015584gpstart:gpmaster:gpadmin-[INFO]:-Obtaining Segment details frommaster...

20130815:21:48:21:015584gpstart:gpmaster:gpadmin-[INFO]:-Setting new master era

20130815:21:48:21:015584gpstart:gpmaster:gpadmin-[INFO]:-Master Started...

20130815:21:48:21:015584gpstart:gpmaster:gpadmin-[INFO]:-Checking for filespaceconsistency

20130815:21:48:21:015584gpstart:gpmaster:gpadmin-[INFO]:-Obtaining current filespaceentries used by TRANSACTION_FILES

20130815:21:48:31:015584gpstart:gpmaster:gpadmin-[INFO]:-TRANSACTION_FILES OIDs areconsistent for pg_system filespace

20130815:21:48:35:015584gpstart:gpmaster:gpadmin-[INFO]:-TRANSACTION_FILES entries areconsistent for pg_system filespace

20130815:21:48:35:015584gpstart:gpmaster:gpadmin-[INFO]:-Checking for filespaceconsistency

20130815:21:48:35:015584gpstart:gpmaster:gpadmin-[INFO]:-Obtaining current filespaceentries used by TEMPORARY_FILES

20130815:21:48:41:015584gpstart:gpmaster:gpadmin-[INFO]:-TEMPORARY_FILES OIDs areconsistent for pg_system filespace

20130815:21:48:47:015584gpstart:gpmaster:gpadmin-[INFO]:-TEMPORARY_FILES entries areconsistent for pg_system filespace

20130815:21:48:47:015584gpstart:gpmaster:gpadmin-[INFO]:-Shutting down master

20130815:21:48:58:015584 gpstart:gpmaster:gpadmin-[INFO]:-Nostandby master configured. skipping...

20130815:21:49:01:015584gpstart:gpmaster:gpadmin-[INFO]:-Commencing parallel segmentinstance startup, please wait...

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

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-Process results...

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:- Successful segment starts = 2

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:- Failed segment starts = 0

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:- Skipped segment starts (segments are marked down inconfiguration) =0

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-Successfully started 2 of 2segment instances

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------

20130815:21:49:46:015584gpstart:gpmaster:gpadmin-[INFO]:-Starting Master instance gpmasterdirectory /data/master/gpseg-1

20130815:21:49:53:015584gpstart:gpmaster:gpadmin-[INFO]:-Command pg_ctl reports Mastergpmaster instance active

20130815:21:49:56:015584gpstart:gpmaster:gpadmin-[INFO]:-Database successfullystarted

20130815:21:49:57:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Completed restart ofGreenplum instance in production mode

20130815:21:49:58:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Loadinggp_toolkit...

20130815:21:50:25:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Scanning utility log file forany warning messages

20130815:21:50:25:003699gpinitsystem:gpmaster:gpadmin-[WARN]:-*******************************************************

20130815:21:50:26:003699gpinitsystem:gpmaster:gpadmin-[WARN]:-Scan of log file indicatesthat some warnings or errors

20130815:21:50:26:003699gpinitsystem:gpmaster:gpadmin-[WARN]:-were generated during thearray creation

20130815:21:50:27:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Please review contents of logfile

20130815:21:50:27:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20130815.log

20130815:21:50:28:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-To determine level ofcriticality

20130815:21:50:28:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-These messages could be froma previous run of the utility

20130815:21:50:29:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-that was calledtoday!

20130815:21:50:29:003699gpinitsystem:gpmaster:gpadmin-[WARN]:-*******************************************************

20130815:21:50:30:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Greenplum Database instancesuccessfully created

20130815:21:50:31:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-------------------------------------------------------

20130815:21:50:31:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-To complete the environmentconfiguration, please

20130815:21:50:32:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-update gpadmin .bashrc filewith the following

20130815:21:50:32:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-1. Ensure that thegreenplum_path.sh file is sourced

20130815:21:50:33:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-2. Add "exportMASTER_DATA_DIRECTORY=/data/master/gpseg-1"

20130815:21:50:33:003699gpinitsystem:gpmaster:gpadmin-[INFO]:- toaccess the Greenplum scripts for this instance:

20130815:21:50:34:003699gpinitsystem:gpmaster:gpadmin-[INFO]:- or,use -d /data/master/gpseg-1 option for the Greenplumscripts

20130815:21:50:34:003699gpinitsystem:gpmaster:gpadmin-[INFO]:- Example gpstate -d /data/master/gpseg-1

20130815:21:50:35:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Script log file =/home/gpadmin/gpAdminLogs/gpinitsystem_20130815.log

20130815:21:50:35:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-To remove instance, rungpdeletesystem utility

20130815:21:50:36:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-To initialize a StandbyMaster Segment for this Greenplum instance

20130815:21:50:36:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Review options forgpinitstandby

20130815:21:50:37:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-------------------------------------------------------

20130815:21:50:37:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-The Master/data/master/gpseg-1/pg_hba.conf post gpinitsystem

20130815:21:50:38:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-has been configured to allowall hosts within this new

20130815:21:50:38:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-array to intercommunicate.Any hosts external to this

20130815:21:50:39:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-new array must be explicitlyadded to this file

20130815:21:50:39:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-Refer to the Greenplum Adminsupport guide which is

20130815:21:50:40:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-located in the/usr/local/greenplum-db/./docs directory

20130815:21:50:40:003699gpinitsystem:gpmaster:gpadmin-[INFO]:-------------------------------------------------------

1.2 设置gp环境变量

.bash_profile文件中添加

exportMASTER_DATA_DIRECTORY=/data/master/gpseg-1

[gpadmin@gpmaster ~]$ vi .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

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

export MASTER_DATA_DIRECTORY=/data/master/gpseg-1

========================================================================================

==本博所有内容均由数据库男本人实际工作环境或模拟操作过程，如有编辑错误或其他问题请和本==

==人留言或联系。发扬互联网精神，一起学习，共同努力，完成由专注到卓越的飞跃。？！？ ==

==QQ:77113981 ！！ @ ============= ==

========================================================================================

1 0