greenplum安裝部署
環境描述：
master一臺：centos6.7 4核4G
主機名：gp-matser;IP:172.30.248.18
segment兩臺：centos6.7 4核4G
主機名：gp-segment1;IP:172.30.251.189
主機名：gp-segment2;IP:172.30.251.19
GP DB版本號：4.3.8.0
一：作業系統環境設定：
1、檢查所有主機的SElinux服務為關閉狀態：
[root@gp-master ~]# sestatus
SELinux status: disabled
如果沒有關閉，修改/etc/selinux/config中SELinux欄位置為disable；
2、檢查所有主機的iptables服務為關閉狀態：
[root@gp-master ~]# /sbin/chkconfig --list iptables
iptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off
如果iptables服務未關閉，執行：#/sbin/chkconfig iptables off
3、修改所有主機的/etc/sysctl.conf檔案，以下是最小配置：
kernel.shmmax =500000000
kernel.shmmni =4096
kernel.shmall =4000000000
kernel.sem =2505120001002048
kernel.sysrq =1
kernel.core_uses_pid =1
kernel.msgmnb =65536
kernel.msgmax =65536
kernel.msgmni =2048
net.ipv4.tcp_syncookies =1
net.ipv4.ip_forward =0
net.ipv4.conf.default.accept_source_route =0
net.ipv4.tcp_tw_recycle =1
net.ipv4.tcp_max_syn_backlog =4096
net.ipv4.conf.all.arp_filter =1
net.ipv4.ip_local_port_range =102565535
net.core.netdev_max_backlog =10000
net.core.rmem_max =2097152
net.core.wmem_max =2097152
vm.overcommit_memory =2
修改要求：
1）圖示欄位必須包含；
2）欄位值不低於圖示值；
3）Segment節點圖示引數值必須一致；
執行sysctl -p重新載入引數
4、修改/etc/security/limit.conf檔案，設定檔案開啟數等限制：
* soft nofile65536
* hard nofile65536
* soft nproc131072
* hard nproc131072
5、修改所有主機的/etc/hosts檔案，增加所有主機資訊
[root@gp-master ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain
172.30.248.18 gp-matser
172.30.251.189 gp-segment1
172.30.251.19 gp-segment2
6、設定所有主機所有磁碟分割槽的read-ahead value大小為16384
[root@gp-master ~]# /sbin/blockdev --getra /dev/vda
256
[root@gp-master ~]# /sbin/blockdev --setra 16384 /dev/vda
[root@gp-master ~]# /sbin/blockdev --setra 16384 /dev/vdb
[root@gp-master ~]# /sbin/blockdev --getra /dev/vda
16384
7、linux磁碟IO排程器對磁碟的訪問支援不同的策略，預設的CFQ，GP建議設定為deadline
[root@gp-matser ~]# more /sys/block/vda/queue/scheduler
noop anticipatory deadline [cfq]
[root@gp-master ~]# echo deadline > /sys/block/vda/queue/scheduler
[root@gp-master ~]# echo deadline > /sys/block/vdb/queue/scheduler
[root@gp-master ~]# more /sys/block/vda/queue/scheduler
noop anticipatory [deadline] cfq
8、修改所有主機/boot/grub/grub.conf檔案，增加或修改圖示紅色標記的欄位：
[root@gp-master ~]# vi /boot/grub/grub.conf
# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You do not have a /boot partition. This means that
# all kernel and initrd paths are relative to /, eg.
# root (hd0,0)
# kernel /boot/vmlinuz-version ro root=/dev/vda1
# initrd /boot/initrd-[generic-]version.img
#boot=/dev/vda
default=0
timeout=1
splashimage=(hd0,0)/boot/grub/splash.xpm.gz
hiddenmenu
title CentOS (2.6.32-573.18.1.el6.x86_64)
root (hd0,0)
kernel /boot/vmlinuz-2.6.32-573.18.1.el6.x86_64 ro root=UUID=f971dd78-8d9e-41bf-8501-edf2e6c0e7ae rd_NO_LUKS KEYBOARDTYPE=pc KEYTABLE=us LANG=en_US.UTF-8 rd_NO_MD console=ttyS0,115200n8 console=tty0 elevator=deadline crashkernel=auto SYSFONT=latarcyrheb-sun16 rd_NO_LVM rd_NO_DM
initrd /boot/initramfs-2.6.32-573.18.1.el6.x86_64.img
title CentOS 6 (2.6.32-573.el6.x86_64)
root (hd0,0)
kernel /boot/vmlinuz-2.6.32-573.el6.x86_64 ro root=UUID=f971dd78-8d9e-41bf-8501-edf2e6c0e7ae rd_NO_LUKS KEYBOARDTYPE=pc KEYTABLE=us LANG=en_US.UTF-8 rd_NO_MD console=ttyS0,115200n8 console=tty0 elevator=deadline crashkernel=auto SYSFONT=latarcyrheb-sun16 rd_NO_LVM rd_NO_DM
initrd /boot/initramfs-2.6.32-573.el6.x86_64.img
9、檢查所有主機的THP服務都為disable狀態
[root@gp-master ~]# cat /sys/kernel/mm/*transparent_hugepage/enabled
[always] madvise never
[always] madvise never
否則修改或者增加/boot/grub/grub.conf檔案中標紅的引數
.....
kernel /boot/vmlinuz-2.6.32-573.18.1.el6.x86_64 ro root=UUID=f971dd78-8d9e-41bf-8501-edf2e6c0e7ae rd_NO_LUKS KEYBOARDTYPE=pc KEYTABLE=us LANG=en_US.UTF-8 rd_NO_MD console=ttyS0,115200n8 console=tty0 elevator=deadline crashkernel=auto SYSFONT=latarcyrheb-sun16 rd_NO_LVM rd_NO_DM transparent_hugepage=never
initrd /boot/initramfs-2.6.32-573.18.1.el6.x86_64.img
10、建立GP使用者
groupadd gpadmin
useradd gpadmin -g gpadmin -d /home/gpadmin
11、分別建立各資料節點檔案（一個含master、一個不含）
[root@gp-master GP]# vi /tmp/all_key
gp-master
gp-segment1
gp-segment2
[root@gp-master GP]# vi /tmp/segment_key
gp-segment1
gp-segment2
12、重啟所有主機
二、GP叢集安裝
下載地址：
1、上傳並解壓安裝包
[root@gp-master greenplum]# unzip greenplum-db-4.3.8.0-build-1-RHEL5-x86_64.zip
2、執行安裝
[root@gp-master greenplum]# ./greenplum-db-4.3.8.0-build-1-RHEL5-x86_64.bin
.....................
I HAVE READ AND AGREE TO THE TERMS OF THE ABOVE PIVOTAL SOFTWARE
LICENSE AGREEMENT.
********************************************************************************
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.8.0
********************************************************************************
/disk/GP（此處是設定GP安裝目錄，不然預設是在根目錄下）
********************************************************************************
Install Greenplum Database into </disk/GP >? [yes|no]
********************************************************************************
yes
********************************************************************************
/usr/local/greenplum-db-4.3.8.0 does not exist.
Create /usr/local/greenplum-db-4.3.8.0 ? [yes|no]
(Selecting no will exit the installer)
********************************************************************************
yes
Extracting product to /usr/local/greenplum-db-4.3.8.0
********************************************************************************
Installation complete.
Greenplum Database is installed in /usr/local/greenplum-db-4.3.8.0
Pivotal Greenplum documentation is available
for download at ]
安裝完結果如下
[root@gp-master GP]# ls -l
total 280
drwxr-xr-x 3 gpadmin gpadmin 4096 Mar 28 15:33 bin
drwxr-xr-x 2 gpadmin gpadmin 4096 Mar 28 15:20 demo
drwxr-xr-x 5 gpadmin gpadmin 4096 Mar 28 15:23 docs
drwxr-xr-x 2 gpadmin gpadmin 4096 Mar 28 15:23 etc
drwxr-xr-x 3 gpadmin gpadmin 4096 Mar 28 15:23 ext
-rw-r--r-- 1 gpadmin gpadmin 43025 Mar 28 15:33 GPDB-LICENSE.txt
-rw-r--r-- 1 root root 712 Jul 18 17:22 greenplum_path.sh
drwxr-xr-x 6 gpadmin gpadmin 4096 Mar 28 15:23 include
drwxr-xr-x 9 gpadmin gpadmin 4096 Mar 28 15:30 lib
-rw-r--r-- 1 gpadmin gpadmin 192912 Mar 28 15:33 LICENSE.thirdparty
drwxr-xr-x 2 gpadmin gpadmin 4096 Mar 28 15:33 sbin
drwxr-xr-x 4 gpadmin gpadmin 4096 Mar 28 15:20 share
3、修改並過載環境變數，增加兩條標紅的記錄
[root@gp-master GP]# vi ~/.bashrc
# .bashrc
# User specific aliases and functions
alias rm='rm -i'
alias cp='cp -i'
alias mv='mv -i'
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
source /disk/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/disk/master/gpseg-1
過載
[root@gp-master GP]# source ~/.bashrc
4、建立伺服器間的互信
[root@gp-master bin]# gpssh-exkeys -f /tmp/all_key
[STEP 1 of 5] create local ID and authorize on local host
... /root/.ssh/id_rsa file exists ... key generation skipped
[STEP 2 of 5] keyscan all hosts and update known_hosts file
[STEP 3 of 5] authorize current user on remote hosts
... send to gp-segment1
***
*** Enter password for gp-segment1:
... send to gp-segment2
[STEP 4 of 5] determine common authentication file content
[STEP 5 of 5] copy authentication files to all remote hosts
... finished key exchange with gp-segment1
... finished key exchange with gp-segment2
[INFO] completed successfully
檢查互信是否OK（登入其他伺服器無須輸入密碼）
[root@gp-master bin]# ssh gp-segment2
Last login: Mon Jul 18 16:46:41 2016 from 192.168.16.19
[root@gp-segment2 ~]#
5、把包傳送到各個segment上，並建立使用者等
[root@gp-master bin]# gpseginstall -f /tmp/all_key -u gpadmin -p 123456
20160719:11:48:56:005449 gpseginstall:gp-master:root-[INFO]:-Installation Info:
link_name greenplum-db
binary_path /disk/GP
binary_dir_location /disk
binary_dir_name GP
20160719:11:48:56:005449 gpseginstall:gp-master:root-[INFO]:-check cluster password access
20160719:11:48:57:005449 gpseginstall:gp-master:root-[INFO]:-de-duplicate hostnames
20160719:11:48:57:005449 gpseginstall:gp-master:root-[INFO]:-master hostname: gp-master
20160719:11:48:57:005449 gpseginstall:gp-master:root-[INFO]:-check for user gpadmin on cluster
20160719:11:48:57:005449 gpseginstall:gp-master:root-[INFO]:-add user gpadmin on master
20160719:11:48:57:005449 gpseginstall:gp-master:root-[INFO]:-add user gpadmin on cluster
20160719:11:48:58:005449 gpseginstall:gp-master:root-[INFO]:-chown -R gpadmin:gpadmin /disk/greenplum-db
20160719:11:48:58:005449 gpseginstall:gp-master:root-[INFO]:-chown -R gpadmin:gpadmin /disk/GP
20160719:11:48:58:005449 gpseginstall:gp-master:root-[INFO]:-rm -f /disk/GP.tar; rm -f /disk/GP.tar.gz
20160719:11:48:58:005449 gpseginstall:gp-master:root-[INFO]:-cd /disk; tar cf GP.tar GP
20160719:11:49:00:005449 gpseginstall:gp-master:root-[INFO]:-gzip /disk/GP.tar
20160719:11:49:22:005449 gpseginstall:gp-master:root-[INFO]:-remote command: mkdir -p /disk
20160719:11:49:22:005449 gpseginstall:gp-master:root-[INFO]:-remote command: rm -rf /disk/GP
20160719:11:49:22:005449 gpseginstall:gp-master:root-[INFO]:-scp software to remote location
20160719:11:49:25:005449 gpseginstall:gp-master:root-[INFO]:-remote command: gzip -f -d /disk/GP.tar.gz
20160719:11:49:30:005449 gpseginstall:gp-master:root-[INFO]:-md5 check on remote location
20160719:11:49:32:005449 gpseginstall:gp-master:root-[INFO]:-remote command: cd /disk; tar xf GP.tar
20160719:11:49:41:005449 gpseginstall:gp-master:root-[INFO]:-remote command: rm -f /disk/GP.tar
20160719:11:49:44:005449 gpseginstall:gp-master:root-[INFO]:-remote command: cd /disk; rm -f greenplum-db; ln -fs GP greenplum-db
20160719:11:49:44:005449 gpseginstall:gp-master:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /disk/greenplum-db
20160719:11:49:44:005449 gpseginstall:gp-master:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /disk/GP
20160719:11:49:45:005449 gpseginstall:gp-master:root-[INFO]:-rm -f /disk/GP.tar.gz
20160719:11:49:45:005449 gpseginstall:gp-master:root-[INFO]:-Changing system passwords ...
20160719:11:49:45:005449 gpseginstall:gp-master:root-[INFO]:-exchange ssh keys for user root
20160719:11:49:46:005449 gpseginstall:gp-master:root-[INFO]:-exchange ssh keys for user gpadmin
20160719:11:49:47:005449 gpseginstall:gp-master:root-[INFO]:-/disk/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20160719:11:49:47:005449 gpseginstall:gp-master:root-[INFO]:-remote command: . /disk/greenplum-db/./greenplum_path.sh; /disk/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20160719:11:49:48:005449 gpseginstall:gp-master:root-[INFO]:-version string on master: gpssh version 4.3.8.0 build 1
20160719:11:49:48:005449 gpseginstall:gp-master:root-[INFO]:-remote command: . /disk/greenplum-db/./greenplum_path.sh; /disk/greenplum-db/./bin/gpssh --version
20160719:11:49:48:005449 gpseginstall:gp-master:root-[INFO]:-remote command: . /disk/GP/greenplum_path.sh; /disk/GP/bin/gpssh --version
20160719:11:49:53:005449 gpseginstall:gp-master:root-[INFO]:-SUCCESS -- Requested commands completed
6、給segment節點建立資料目錄並賦予許可權
[root@gp-master bin]# gpssh -f /tmp/segment_key -e 'mkdir -p /disk/DB'
[gp-segment1] mkdir -p /disk/DB
[gp-segment2] mkdir -p /disk/DB
[root@gp-master bin]# gpssh -f /tmp/segment_key -e 'chown gpadmin:gpadmin /disk/DB'
[gp-segment1] chown gpadmin:gpadmin /disk/DB
[gp-segment2] chown gpadmin:gpadmin /disk/DB
7、時間系統同步，master向時間伺服器同步，segment向master同步,增加檔案中標紅的引數
[root@gp-master ~]# vi /etc/ntp.conf
server 192.168.129.150
[root@gp-segment1 ~]# vi /etc/ntp.conf
server gp-master
[root@gp-segment2 ~]# vi /etc/ntp.conf
server gp-master
[root@gp-master ~]# gpssh -f /tmp/all_key -v -e 'ntpd'
[WARN] Reference default values as $MASTER_DATA_DIRECTORY/gpssh.conf could not be found
Using delaybeforesend 0.05 and prompt_validation_timeout 1.0
[Reset ...]
[INFO] login gp-segment2
[INFO] login gp-master
[INFO] login gp-segment1
[gp-segment2] ntpd
[ gp-master] ntpd
[gp-segment1] ntpd
[INFO] completed successfully
8、檢查引數設定
[root@gp-master ~]# gpcheck -f /tmp/all_key -m gp-master -s gp-segment1
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-dedupe hostnames
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-Detected platform: Generic Linux Cluster
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-generate data on servers
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-copy data files from servers
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-delete remote tmp files
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-Using gpcheck config file: /disk/greenplum-db/./etc/gpcheck.cnf
20160719:19:46:43:007472 gpcheck:gp-master:root-[ERROR]:-GPCHECK_ERROR host(gp-segment2): uname -r output different among hosts: gp-master : 2.6.32-573.18.1.el6.x86_64 != gp-segment2 : 2.6.32-573.el6.x86_64
20160719:19:46:43:007472 gpcheck:gp-master:root-[ERROR]:-GPCHECK_ERROR host(gp-segment1): uname -r output different among hosts: gp-master : 2.6.32-573.18.1.el6.x86_64 != gp-segment1 : 2.6.32-573.el6.x86_64
20160719:19:46:43:007472 gpcheck:gp-master:root-[INFO]:-gpcheck completing...
由於是在虛擬機器上安裝，這個錯誤忽略
三、初始化叢集
1、在matser上進入gpadmin使用者，建立配置檔案
[root@gp-master ~]# su - gpadmin
[gpadmin@gp-master ~]$ source /disk/greenplum-db/greenplum_path.sh
[gpadmin@gp-master ~]$ mkdir gpconfigs
[gpadmin@gp-master ~]$ cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config /home/gpadmin/gpconfigs/gpinitsystem_config
2、修改配置檔案
[gpadmin@gp-master ~]$ cd gpconfigs/
[gpadmin@gp-master ~]$ vi gpinitsystem_config
declare -a DATA_DIRECTORY=(/disk/DB)
MASTER_HOSTNAME=gp-master
MASTER_DIRECTORY=/disk/master （這個目錄要預先建立並且屬主是gpadmin）
MASTER_PORT=5432
TRUSTED_SHELL=ssh
CHECK_POINT_SEGMENTS=8
ENCODING=UTF8
3、初始化
[gpadmin@gp-master gpconfigs]$ gpinitsystem -c gpinitsystem_config -h /tmp/segment_key
20160719:20:14:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20160719:20:14:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20160719:20:14:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Locale set to en_US.utf8
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checking configuration parameters, Completed
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
..
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Configuring build for standard array
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20160719:20:14:42:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Building primary segment instance array, please wait...
..
20160719:20:14:43:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checking Master host
20160719:20:14:43:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checking new segment hosts, please wait...
..
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checking new segment hosts, Completed
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:---------------------------------------
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master Configuration
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:---------------------------------------
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master instance name = EMC Greenplum DW
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master hostname = gp-master
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master port = 5432
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master instance dir = /disk/master/gpseg-1
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Greenplum segment prefix = gpseg
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master Database =
20160719:20:14:44:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master connections = 250
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master buffers = 128000kB
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Segment connections = 750
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Segment buffers = 128000kB
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Checkpoint segments = 8
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Encoding = UTF8
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Postgres param file = Off
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Initdb to be used = /disk/greenplum-db/./bin/initdb
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /disk/greenplum-db/./lib
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Ulimit check = Passed
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master IP address [1] = ::1
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master IP address [2] = 172.30.248.18
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Master IP address [3] = fe80::f816:3eff:fe15:2242
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Standby Master = Not Configured
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Primary segment # = 1
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Total Database segments = 2
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Trusted shell = ssh
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Number segment hosts = 2
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Mirroring config = OFF
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:----------------------------------------
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:----------------------------------------
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-gp-segment1 /disk/DB/gpseg0 40000 2 0
20160719:20:14:45:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-gp-segment2 /disk/DB/gpseg1 40000 3 1
Continue with Greenplum creation Yy/Nn>
y
20160719:20:14:50:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Building the Master instance database, please wait...
20160719:20:15:05:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Starting the Master in admin mode
20160719:20:15:09:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20160719:20:15:09:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
..
20160719:20:15:10:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
............................................................................................................................................
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:------------------------------------------------
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Parallel process exit status
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:------------------------------------------------
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Total processes marked as completed = 2
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Total processes marked as killed = 0
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Total processes marked as failed = 0
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:------------------------------------------------
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Deleting distributed backout files
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Removing back out file
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-No errors generated from parallel processes
20160719:20:17:30:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /disk/master/gpseg-1
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Obtaining Segment details from master...
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-There are 0 connections to the database
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Master host=gp-master
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20160719:20:17:31:021932 gpstop:gp-master:gpadmin-[INFO]:-Master segment instance directory=/disk/master/gpseg-1
20160719:20:17:32:021932 gpstop:gp-master:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20160719:20:17:32:021932 gpstop:gp-master:gpadmin-[INFO]:-Terminating processes for segment /disk/master/gpseg-1
20160719:20:17:32:022019 gpstart:gp-master:gpadmin-[INFO]:-Starting gpstart with args: -a -d /disk/master/gpseg-1
20160719:20:17:32:022019 gpstart:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...
20160719:20:17:32:022019 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'
20160719:20:17:32:022019 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20160719:20:17:32:022019 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance in admin mode
20160719:20:17:33:022019 gpstart:gp-master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20160719:20:17:33:022019 gpstart:gp-master:gpadmin-[INFO]:-Obtaining Segment details from master...
20160719:20:17:33:022019 gpstart:gp-master:gpadmin-[INFO]:-Setting new master era
20160719:20:17:33:022019 gpstart:gp-master:gpadmin-[INFO]:-Master Started...
20160719:20:17:33:022019 gpstart:gp-master:gpadmin-[INFO]:-Shutting down master
20160719:20:17:34:022019 gpstart:gp-master:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
...
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-Process results...
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:- Successful segment starts = 2
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:- Failed segment starts = 0
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:17:37:022019 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance gp-master directory /disk/master/gpseg-1
20160719:20:17:38:022019 gpstart:gp-master:gpadmin-[INFO]:-Command pg_ctl reports Master gp-master instance active
20160719:20:17:39:022019 gpstart:gp-master:gpadmin-[INFO]:-No standby master configured. skipping...
20160719:20:17:39:022019 gpstart:gp-master:gpadmin-[INFO]:-Database successfully started
20160719:20:17:39:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20160719:20:17:39:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Loading gp_toolkit...
20160719:20:17:40:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20160719:20:17:40:010943 gpinitsystem:gp-master:gpadmin-[WARN]:-*******************************************************
20160719:20:17:40:010943 gpinitsystem:gp-master:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[WARN]:-were generated during the array creation
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Please review contents of log file
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20160719.log
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-To determine level of criticality
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-that was called today!
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[WARN]:-*******************************************************
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Greenplum Database instance successfully created
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-------------------------------------------------------
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-To complete the environment configuration, please
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/disk/master/gpseg-1"
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:- or, use -d /disk/master/gpseg-1 option for the Greenplum scripts
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:- Example gpstate -d /disk/master/gpseg-1
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20160719.log
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Review options for gpinitstandby
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-------------------------------------------------------
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-The Master /disk/master/gpseg-1/pg_hba.conf post gpinitsystem
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-new array must be explicitly added to this file
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-located in the /disk/greenplum-db/./docs directory
20160719:20:17:41:010943 gpinitsystem:gp-master:gpadmin-[INFO]:-------------------------------------------------------
4、檢視GP叢集狀態
[gpadmin@gp-master ~]$ gpstate
20160719:20:22:38:023717 gpstate:gp-master:gpadmin-[INFO]:-Starting gpstate with args:
20160719:20:22:38:023717 gpstate:gp-master:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'
20160719:20:22:38:023717 gpstate:gp-master:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.8.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Mar 28 2016 00:15:29'
20160719:20:22:38:023717 gpstate:gp-master:gpadmin-[INFO]:-Obtaining Segment details from master...
20160719:20:22:38:023717 gpstate:gp-master:gpadmin-[INFO]:-Gathering data from segments...
.
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-Greenplum instance status summary
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Master instance = Active
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Master standby = No master standby configured
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total segment instance count from metadata = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Primary Segment Status
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total primary segments = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total primary segment valid (at master) = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of postmaster.pid files found = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number of /tmp lock files found = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Total number postmaster processes found = 2
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Mirror Segment Status
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:- Mirrors not configured on this array
20160719:20:22:39:023717 gpstate:gp-master:gpadmin-[INFO]:-----------------------------------------------------
正常沒有error
5、重啟叢集
[gpadmin@gp-master ~]$ gpstop -M fast
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Starting gpstop with args: -M fast
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Obtaining Segment details from master...
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:---------------------------------------------
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Master instance parameters
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:---------------------------------------------
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Master Greenplum instance process active PID = 22078
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Database = template1
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Master port = 5432
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Master directory = /disk/master/gpseg-1
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Shutdown mode = fast
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Timeout = 120
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Shutdown Master standby host = Off
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:---------------------------------------------
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:-Segment instances that will be shutdown:
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:---------------------------------------------
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- Host Datadir Port Status
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- gp-segment1 /disk/DB/gpseg0 40000 u
20160719:20:23:30:023798 gpstop:gp-master:gpadmin-[INFO]:- gp-segment2 /disk/DB/gpseg1 40000 u
Continue with Greenplum instance shutdown Yy|Nn (default=N):
> y
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-There are 0 connections to the database
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast'
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Master host=gp-master
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Detected 0 connections to database
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Using standard WAIT mode of 120 seconds
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=fast
20160719:20:23:34:023798 gpstop:gp-master:gpadmin-[INFO]:-Master segment instance directory=/disk/master/gpseg-1
20160719:20:23:35:023798 gpstop:gp-master:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20160719:20:23:35:023798 gpstop:gp-master:gpadmin-[INFO]:-Terminating processes for segment /disk/master/gpseg-1
20160719:20:23:35:023798 gpstop:gp-master:gpadmin-[INFO]:-No standby master host configured
20160719:20:23:35:023798 gpstop:gp-master:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20160719:20:23:35:023798 gpstop:gp-master:gpadmin-[INFO]:-0.00% of jobs completed
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-100.00% of jobs completed
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:- Segments stopped successfully = 2
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:- Segments with errors during stop = 0
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-Successfully shutdown 2 of 2 segment instances
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-No leftover gpmmon process found
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20160719:20:23:45:023798 gpstop:gp-master:gpadmin-[INFO]:-Cleaning up leftover shared memory
[gpadmin@gp-master ~]$ gpstart
20160719:20:25:00:023903 gpstart:gp-master:gpadmin-[INFO]:-Starting gpstart with args:
20160719:20:25:00:023903 gpstart:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...
20160719:20:25:00:023903 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'
20160719:20:25:00:023903 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20160719:20:25:00:023903 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance in admin mode
20160719:20:25:01:023903 gpstart:gp-master:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20160719:20:25:01:023903 gpstart:gp-master:gpadmin-[INFO]:-Obtaining Segment details from master...
20160719:20:25:01:023903 gpstart:gp-master:gpadmin-[INFO]:-Setting new master era
20160719:20:25:01:023903 gpstart:gp-master:gpadmin-[INFO]:-Master Started...
20160719:20:25:01:023903 gpstart:gp-master:gpadmin-[INFO]:-Shutting down master
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:---------------------------
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Master instance parameters
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:---------------------------
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Database = template1
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Master Port = 5432
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Master directory = /disk/master/gpseg-1
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Timeout = 600 seconds
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Master standby = Off
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:---------------------------------------
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:-Segment instances that will be started
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:---------------------------------------
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:- Host Datadir Port
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:- gp-segment1 /disk/DB/gpseg0 40000
20160719:20:25:02:023903 gpstart:gp-master:gpadmin-[INFO]:- gp-segment2 /disk/DB/gpseg1 40000
Continue with Greenplum instance startup Yy|Nn (default=N):
> y
20160719:20:25:06:023903 gpstart:gp-master:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
...
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-Process results...
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:- Successful segment starts = 2
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:- Failed segment starts = 0
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-----------------------------------------------------
20160719:20:25:09:023903 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance gp-master directory /disk/master/gpseg-1
20160719:20:25:10:023903 gpstart:gp-master:gpadmin-[INFO]:-Command pg_ctl reports Master gp-master instance active
20160719:20:25:10:023903 gpstart:gp-master:gpadmin-[INFO]:-No standby master configured. skipping...
20160719:20:25:10:023903 gpstart:gp-master:gpadmin-[INFO]:-Database successfully started
6、進去叢集
[gpadmin@gp-master gpconfigs]$ psql -p5432 -dpostgres
psql (8.2.15)
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Access privileges
-----------+---------+----------+---------------------
postgres | gpadmin | UTF8 |
template0 | gpadmin | UTF8 | =c/gpadmin
: gpadmin=CTc/gpadmin
template1 | gpadmin | UTF8 | =c/gpadmin
: gpadmin=CTc/gpadmin
(3 rows)
今天就介紹到這，後續將記錄更多有關GP的管理和最佳化
今天就介紹到這，後續將記錄更多有關GP的管理和最佳化
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29989552/viewspace-2123042/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- greenplum 4.3.33安裝
- greenplum單節點安裝
- GreenPlum資料庫安裝資料庫
- Greenplum安裝dblink模組
- GreenPlum的安裝步驟
- 【GP】greenplum監控軟體Greenplum-cc-web的安裝Web
- 安裝Greenplum 5.2 叢集實戰
- Greenplum_原始碼編譯安裝和RPM包安裝原始碼編譯
- Centos7安裝greenplum遇到的問題CentOS
- greenplum6.14、GPCC6.4安裝詳解
- Zabbix安裝部署
- canal安裝部署
- Doris安裝部署
- SQLT 安裝部署SQL
- ZooKeeper 安裝部署
- Dubbo安裝部署
- Zookeeper安裝部署
- ELK安裝部署
- chromedriver安裝部署Chrome
- centos7.3下 greenplum-db 安裝、配置文件CentOS
- 安裝GP CCC（Greenplum Command Center Console）
- Centos7安裝安裝部署dockerCentOSDocker
- SQOOP安裝部署OOP
- Oozie--安裝部署
- Apache Ranger安裝部署ApacheRanger
- Hive 3.1.2安裝部署Hive
- Saltstack基本安裝部署
- RocketMQ安裝及部署MQ
- flume的安裝部署
- Linux安裝部署Linux
- Hive的安裝部署Hive
- Redis之安裝部署Redis
- cloudstack +xenserver 安裝部署CloudServer
- 安裝部署VMware VCenter
- 安裝go 1.5 & 部署Go
- Hadoop 安裝部署Hadoop
- openssl安裝與部署
- mysql proxy 安裝部署MySql