greenplum安装部署

最新推荐文章于 2022-06-14 16:06:26 发布

ckqq46580

最新推荐文章于 2022-06-14 16:06:26 发布

阅读量668

点赞数

文章标签：数据库运维操作系统

本文详细介绍了如何在CentOS 6.7环境下部署Greenplum Database (GPDB) 4.3.8.0版本的步骤。包括操作系统环境的配置、GP集群的安装与初始化、集群状态的检查及重启等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

环境描述：

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

否则修改或者增加/boot/grub/grub.conf文件中标红的参数

.....

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集群安装

下载地址：https://network.pivotal.io/products/pivotal-gpdb

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 http://docs.gopivotal.com/gpdb]

安装完结果如下

[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

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>

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的管理和优化

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

转载于:http://blog.itpub.net/29989552/viewspace-2123042/