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

1    初始化数据库

Gpadmin用户执行

1.1  初始化

gpinitsystem  -c /home/gpadmin/gpinitsystem_config

完成过程如下：

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

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

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

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

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

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

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

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

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

..

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

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

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

..

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

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

..

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Continue with Greenplum creation Yy/Nn>

y

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

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

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

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

..

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 

1.2  设置gp环境变量

.bash_profile文件中添加

export MASTER_DATA_DIRECTORY=/data/master/gpseg-1

[gpadmin@gpmaster ~]$ vi .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

# 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                                                ！！ @  =============    ==

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