ITPub博客

首页 > 大数据 > 数据挖掘 > Linux安装Greenplum全过程

Linux安装Greenplum全过程

原创 数据挖掘 作者:guogongzhou 时间:2015-07-29 14:10:17 0 删除 编辑
OS:Oracle Linux Server release 6.6
Greenplum:
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip 
自定义参数文件
1,
hosts_seg_only 定义所有数据节点
2,
gpinitsystem_config 定义数据库实例信息
[gpadmin@db01 ~]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.172.110 db01.dbadmin.cn 12c mdw sdw1
[root@db01 ~]# ping mdw
PING db01.dbadmin.cn (192.168.172.110) 56(84) bytes of data.
64 bytes from db01.dbadmin.cn (192.168.172.110): icmp_seq=1 ttl=64 time=0.026 ms
64 bytes from db01.dbadmin.cn (192.168.172.110): icmp_seq=2 ttl=64 time=0.053 ms
^C
--- db01.dbadmin.cn ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1435ms
rtt min/avg/max/mdev = 0.026/0.039/0.053/0.014 ms
[root@db01 ~]# ping sdw1
PING db01.dbadmin.cn (192.168.172.110) 56(84) bytes of data.
64 bytes from db01.dbadmin.cn (192.168.172.110): icmp_seq=1 ttl=64 time=0.021 ms
64 bytes from db01.dbadmin.cn (192.168.172.110): icmp_seq=2 ttl=64 time=0.103 ms
^C
--- db01.dbadmin.cn ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1517ms
rtt min/avg/max/mdev = 0.021/0.062/0.103/0.041 ms
[root@db01 ~]# ls
anaconda-ks.cfg  install.log         Pictures                      Videos
Desktop          install.log.syslog  Public
Documents        iso                 rlwrap-0.37-1.el6.x86_64.rpm
Downloads        Music               Templates
[root@db01 ~]# mv /home/oracle/greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip .
[root@db01 ~]# ls
anaconda-ks.cfg                                iso
Desktop                                        Music
Documents                                      Pictures
Downloads                                      Public
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip  rlwrap-0.37-1.el6.x86_64.rpm
install.log                                    Templates
install.log.syslog                             Videos
[root@db01 ~]# ls
anaconda-ks.cfg                                iso
Desktop                                        Music
Documents                                      Pictures
Downloads                                      Public
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip  rlwrap-0.37-1.el6.x86_64.rpm
install.log                                    Templates
install.log.syslog                             Videos
[root@db01 ~]# unzip greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip
Archive:  greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip
  inflating: README_INSTALL
  inflating: greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.bin
[root@db01 ~]# ls
anaconda-ks.cfg                                iso
Desktop                                        Music
Documents                                      Pictures
Downloads                                      Public
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.bin  README_INSTALL
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip  rlwrap-0.37-1.el6.x86_64.rpm
install.log                                    Templates
install.log.syslog                             Videos
[root@db01 ~]# ./greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.bin

********************************************************************************
You must read and accept the Pivotal Database license agreement
before installing
********************************************************************************

       ***  IMPORTANT INFORMATION - PLEASE READ CAREFULLY  ***

PIVOTAL GREENPLUM DATABASE END USER LICENSE AGREEMENT

IMPORTANT - READ CAREFULLY: This Software contains computer programs and
other proprietary material and information, the use of which is subject to
and expressly conditioned upon acceptance of this End User License
Agreement ("EULA").

This EULA is a legally binding document between you (meaning the person or
the entity that obtained the Software under the terms and conditions of
this EULA, is agreeing to be bound by the terms and conditions of this
EULA, and is referred to below as "You" or "Customer") and Pivotal (meaning
(i) Pivotal Software, Inc., if Customer is located in the United States;
and (ii) the local Pivotal sales subsidiary, if Customer is located in a
country outside the United States in which Pivotal has a local sales
subsidiary; and (iii) GoPivotal International Limited, if Customer is
located in a country outside the United States in which Pivotal does not
have a local sales subsidiary (in each case, referred to herein as
"Pivotal"). Unless Customer has entered into a written and separately
signed agreement with Pivotal that is currently in effect with respect to

********************************************************************************
Do you accept the Pivotal Database license agreement? [yes|no]
********************************************************************************

yes

********************************************************************************
Provide the installation path for Greenplum Database or press ENTER to
accept the default installation path: /usr/local/greenplum-db-4.3.5.0
********************************************************************************



********************************************************************************
Install Greenplum Database into </usr/local/greenplum-db-4.3.5.0>? [yes|no]
********************************************************************************

yes

********************************************************************************
/usr/local/greenplum-db-4.3.5.0 does not exist.
sdw1
Create /usr/local/greenplum-db-4.3.5.0 ? [yes|no]
(Selecting no will exit the installer)
********************************************************************************

yes

Extracting product to /usr/local/greenplum-db-4.3.5.0


********************************************************************************
Installation complete.
Greenplum Database is installed in /usr/local/greenplum-db-4.3.5.0

Pivotal Greenplum documentation is available
for download at http://docs.gopivotal.com/gpdb
********************************************************************************
[root@db01 ~]#

[root@db01 ~]# source /usr/local/greenplum-db-4.3.5.0/greenplum_path.sh
[root@db01 ~]# cat /opt/hosts_seg_only
sdw1
[root@db01 ~]# groupadd gpadmin
[root@db01 ~]# useradd -g gpadmin gpadmin
[root@db01 ~]# passwd gpadmin
Changing password for user gpadmin.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
[root@db01 ~]# mkdir -p /u01/greenplum/data/master /u01/greenplum/data/primary
[root@db01 ~]# chown -R gpadmin:gpadmin /u01/greenplum/
[root@db01 ~]# chown -R gpadmin:gpadmin /opt
[root@db01 ~]# ls
anaconda-ks.cfg                                iso
Desktop                                        Music
Documents                                      Pictures
Downloads                                      Public
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.bin  README_INSTALL
greenplum-db-4.3.5.0-build-1-RHEL5-x86_64.zip  rlwrap-0.37-1.el6.x86_64.rpm
hosts_seg_only                                 Templates
install.log                                    Videos
install.log.syslog
[root@db01 ~]# mv hosts_seg_only /opt/
[root@db01 ~]# cd /opt/
[root@db01 opt]# ls
hosts_seg_only  ORCLfmap  rh
[root@db01 opt]# su - gpadmin
[gpadmin@db01 ~]$ cd /opt/
[gpadmin@db01 opt]$ ls
hosts_seg_only  ORCLfmap  rh
[gpadmin@db01 opt]$ cp /usr/local/greenplum-db
greenplum-db/         greenplum-db-4.3.5.0/

[gpadmin@db01 opt]$ cp /usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config ./
[gpadmin@db01 opt]$ ls
gpinitsystem_config  hosts_seg_only  ORCLfmap  rh
[gpadmin@db01 opt]$ ls
gpinitsystem_config  hosts_seg_only  ORCLfmap  rh
[gpadmin@db01 opt]$ ll
total 16
-r--r--r--  1 gpadmin gpadmin 2660 Jul 29 13:58 gpinitsystem_config
-rw-r--r--  1 root    root       5 Jul 29 13:54 hosts_seg_only
drwxr-xr-x  3 gpadmin gpadmin 4096 Jun 25 04:48 ORCLfmap
drwxr-xr-x. 2 gpadmin gpadmin 4096 Oct 10  2013 rh
[root@db01 opt]# cat gpinitsystem_config
# FILE NAME: gpinitsystem_config

# Configuration file needed by the gpinitsystem

################################################
#### REQUIRED PARAMETERS
################################################

#### Name of this Greenplum system enclosed in quotes.
ARRAY_NAME="EMC Greenplum DW"

#### Naming convention for utility-generated data directories.
SEG_PREFIX=gpseg

#### Base number by which primary segment port numbers
#### are calculated.
PORT_BASE=40000

#### File system location(s) where primary segment data directories
#### will be created. The number of locations in the list dictate
#### the number of primary segments that will get created per
#### physical host (if multiple addresses for a host are listed in
#### the hostfile, the number of segments will be spread evenly across
#### the specified interface addresses).
declare -a DATA_DIRECTORY=(/u01/greenplum/data/primary /u01/greenplum/data/primary)

#### OS-configured hostname or IP address of the master host.
MASTER_HOSTNAME=mdw

#### File system location where the master data directory
#### will be created.
MASTER_DIRECTORY=/u01/greenplum/data/master

#### Port number for the master instance.
MASTER_PORT=5432

#### Shell utility used to connect to remote hosts.
TRUSTED_SHELL=ssh

#### Maximum log file segments between automatic WAL checkpoints.
CHECK_POINT_SEGMENTS=8

#### Default server-side character set encoding.
ENCODING=UNICODE

[gpadmin@db01 opt]$ vim ~/.bash_profile
[gpadmin@db01 opt]$ source ~/.bash_profile
[gpadmin@db01 opt]$ exit
logout
[root@db01 opt]# source /usr/local/greenplum-db/greenplum_path.sh
[root@db01 opt]# gpseginstall -f hosts_seg_only -u gpadmin -p gpadmin
20150729:14:08:51:002840 gpseginstall:db01:root-[INFO]:-Installation Info:
link_name greenplum-db
binary_path /usr/local/greenplum-db-4.3.5.0
binary_dir_location /usr/local
binary_dir_name greenplum-db-4.3.5.0
20150729:14:08:51:002840 gpseginstall:db01:root-[INFO]:-check cluster password access
  *** Enter password for sdw1:
20150729:14:08:56:002840 gpseginstall:db01:root-[INFO]:-de-duplicate hostnames
20150729:14:08:56:002840 gpseginstall:db01:root-[INFO]:-master hostname: db01.dbadmin.cn
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-check for user gpadmin on cluster
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-add user gpadmin on master
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-add user gpadmin on cluster
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.3.5.0
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-rm -f /usr/local/greenplum-db-4.3.5.0.tar; rm -f /usr/local/greenplum-db-4.3.5.0.tar.gz
20150729:14:08:57:002840 gpseginstall:db01:root-[INFO]:-cd /usr/local; tar cf greenplum-db-4.3.5.0.tar greenplum-db-4.3.5.0
20150729:14:09:01:002840 gpseginstall:db01:root-[INFO]:-gzip /usr/local/greenplum-db-4.3.5.0.tar
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: mkdir -p /usr/local
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: rm -rf /usr/local/greenplum-db-4.3.5.0
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-scp software to remote location
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: gzip -f -d /usr/local/greenplum-db-4.3.5.0.tar.gz
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-md5 check on remote location
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: cd /usr/local; tar xf greenplum-db-4.3.5.0.tar
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: rm -f /usr/local/greenplum-db-4.3.5.0.tar
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: cd /usr/local; rm -f greenplum-db; ln -fs greenplum-db-4.3.5.0 greenplum-db
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.3.5.0
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-rm -f /usr/local/greenplum-db-4.3.5.0.tar.gz
20150729:14:09:23:002840 gpseginstall:db01:root-[INFO]:-Changing system passwords ...
20150729:14:09:24:002840 gpseginstall:db01:root-[INFO]:-exchange ssh keys for user root
20150729:14:09:25:002840 gpseginstall:db01:root-[INFO]:-exchange ssh keys for user gpadmin
20150729:14:09:26:002840 gpseginstall:db01:root-[INFO]:-/usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20150729:14:09:26:002840 gpseginstall:db01:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20150729:14:09:26:002840 gpseginstall:db01:root-[INFO]:-version string on master: gpssh version 4.3.5.0 build 1
20150729:14:09:26:002840 gpseginstall:db01:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./bin/gpssh --version
20150729:14:09:26:002840 gpseginstall:db01:root-[INFO]:-remote command: . /usr/local/greenplum-db-4.3.5.0/greenplum_path.sh; /usr/local/greenplum-db-4.3.5.0/bin/gpssh --version
20150729:14:09:31:002840 gpseginstall:db01:root-[INFO]:-SUCCESS -- Requested commands completed
[root@db01 opt]# su - gpadmin
[gpadmin@db01 ~]$ cd /opt/
[gpadmin@db01 opt]$ gpinitsystem -c gpinitsystem_config -h hosts_seg_only
20150729:14:11:41:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking configuration parameters, please wait...
/bin/mv: try to overwrite `gpinitsystem_config', overriding mode 0444 (r--r--r--)? y
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Locale set to en_US.utf8
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[WARN]:-Master hostname mdw does not match hostname output
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking to see if mdw can be resolved on this host
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Can resolve mdw to this host
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking configuration parameters, Completed
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
.
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Configuring build for standard array
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20150729:14:13:05:003158 gpinitsystem:db01:gpadmin-[INFO]:-Building primary segment instance array, please wait...
..
20150729:14:13:06:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking Master host
20150729:14:13:06:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking new segment hosts, please wait...
..
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checking new segment hosts, Completed
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:---------------------------------------
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master Configuration
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:---------------------------------------
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master instance name       = EMC Greenplum DW
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master hostname            = mdw
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master port                = 5432
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master instance dir        = /u01/greenplum/data/master/gpseg-1
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master Database            =
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master connections         = 250
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master buffers             = 128000kB
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Segment connections        = 750
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Segment buffers            = 128000kB
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Checkpoint segments        = 8
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Encoding                   = UNICODE
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Postgres param file        = Off
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db/./bin/initdb
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db/./lib
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Ulimit check               = Passed
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master IP address [1]      = ::1
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master IP address [2]      = 192.168.172.110
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Master IP address [3]      = fe80::20c:29ff:fe7b:4806
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Standby Master             = Not Configured
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Primary segment #          = 2
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Total Database segments    = 2
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Trusted shell              = ssh
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Number segment hosts       = 1
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Mirroring config           = OFF
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:----------------------------------------
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20150729:14:13:08:003158 gpinitsystem:db01:gpadmin-[INFO]:----------------------------------------
20150729:14:13:09:003158 gpinitsystem:db01:gpadmin-[INFO]:-sdw1  /u01/greenplum/data/primary/gpseg0  40000  0
20150729:14:13:09:003158 gpinitsystem:db01:gpadmin-[INFO]:-sdw1  /u01/greenplum/data/primary/gpseg1  40001  1
Continue with Greenplum creation Yy/Nn>
y
20150729:14:13:15:003158 gpinitsystem:db01:gpadmin-[INFO]:-Building the Master instance database, please wait...
20150729:14:13:23:003158 gpinitsystem:db01:gpadmin-[INFO]:-Starting the Master in admin mode
20150729:14:13:27:003158 gpinitsystem:db01:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20150729:14:13:27:003158 gpinitsystem:db01:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
..
20150729:14:13:27:003158 gpinitsystem:db01:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
................
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:------------------------------------------------
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Parallel process exit status
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:------------------------------------------------
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Total processes marked as completed           = 2
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Total processes marked as killed              = 0
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Total processes marked as failed              = 0
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:------------------------------------------------
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Deleting distributed backout files
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Removing back out file
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-No errors generated from parallel processes
20150729:14:13:44:003158 gpinitsystem:db01:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /u01/greenplum/data/master/gpseg-1
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Gathering information and validating the environment...
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Obtaining Segment details from master...
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.5.0 build 1'
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-There are 0 connections to the database
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Master host=db01.dbadmin.cn
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20150729:14:13:44:014527 gpstop:db01:gpadmin-[INFO]:-Master segment instance directory=/u01/greenplum/data/master/gpseg-1
20150729:14:13:45:014527 gpstop:db01:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20150729:14:13:45:014527 gpstop:db01:gpadmin-[INFO]:-Terminating processes for segment /u01/greenplum/data/master/gpseg-1
20150729:14:13:45:014617 gpstart:db01:gpadmin-[INFO]:-Starting gpstart with args: -a -d /u01/greenplum/data/master/gpseg-1
20150729:14:13:45:014617 gpstart:db01:gpadmin-[INFO]:-Gathering information and validating the environment...
20150729:14:13:45:014617 gpstart:db01:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.5.0 build 1'
20150729:14:13:46:014617 gpstart:db01:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20150729:14:13:46:014617 gpstart:db01:gpadmin-[INFO]:-Starting Master instance in admin mode
20150729:14:13:47:014617 gpstart:db01:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20150729:14:13:47:014617 gpstart:db01:gpadmin-[INFO]:-Obtaining Segment details from master...
20150729:14:13:47:014617 gpstart:db01:gpadmin-[INFO]:-Setting new master era
20150729:14:13:47:014617 gpstart:db01:gpadmin-[INFO]:-Master Started...
20150729:14:13:47:014617 gpstart:db01:gpadmin-[INFO]:-Shutting down master
20150729:14:13:48:014617 gpstart:db01:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-Process results...
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-----------------------------------------------------
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-   Successful segment starts                                            = 2
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-----------------------------------------------------
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-----------------------------------------------------
20150729:14:13:50:014617 gpstart:db01:gpadmin-[INFO]:-Starting Master instance db01.dbadmin.cn directory /u01/greenplum/data/master/gpseg-1
20150729:14:13:51:014617 gpstart:db01:gpadmin-[INFO]:-Command pg_ctl reports Master db01.dbadmin.cn instance active
20150729:14:13:51:014617 gpstart:db01:gpadmin-[INFO]:-No standby master configured.  skipping...
20150729:14:13:51:014617 gpstart:db01:gpadmin-[INFO]:-Database successfully started
20150729:14:13:51:003158 gpinitsystem:db01:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20150729:14:13:51:003158 gpinitsystem:db01:gpadmin-[INFO]:-Loading gp_toolkit...
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[WARN]:-*******************************************************
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[WARN]:-were generated during the array creation
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Please review contents of log file
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20150729.log
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-To determine level of criticality
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[WARN]:-*******************************************************
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Greenplum Database instance successfully created
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-------------------------------------------------------
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-To complete the environment configuration, please
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/u01/greenplum/data/master/gpseg-1"
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-   or, use -d /u01/greenplum/data/master/gpseg-1 option for the Greenplum scripts
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the PostgreSQL
# documentation for a complete description of this file.  A short
# synopsis follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of these forms:
#
# local      DATABASE  USER  METHOD  [OPTIONS]
# host       DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTIONS]
# hostssl    DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTIONS]
# hostnossl  DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTIONS]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain
# socket, "host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a
# plain TCP/IP socket.
#
# DATABASE can be "all", "sameuser", "samerole", a
# database name, or a comma-separated list thereof.
#
"/u01/greenplum/data/master/gpseg-1/pg_hba.conf" 83L, 4103C                         7,1           Top
# This file is read on server startup and when the postmaster receives
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-   Example gpstate -d /u01/greenplum/data/master/gpseg-1
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20150729.log
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Review options for gpinitstandby
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-------------------------------------------------------
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-The Master /u01/greenplum/data/master/gpseg-1/pg_hba.conf post gpinitsystem
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-new array must be explicitly added to this file
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20150729:14:13:52:003158 gpinitsystem:db01:gpadmin-[INFO]:-------------------------------------------------------

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22803429/viewspace-1755310/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle归档模式
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-09-01

  • 博文量
    2
  • 访问量
    7515