ITPub博客

首页 > 数据库 > 国内数据库 > greenplum 6.9 for centos7集群搭建步骤

greenplum 6.9 for centos7集群搭建步骤

原创 国内数据库 作者:chenfeng 时间:2020-10-14 16:06:42 0 删除 编辑


Host            IP                                功能

mdw       192.168.1.1                master

smdw      192.168.1.2                         segment

sdw2      192.168.1.3                         segment



greenplum6.9下载:

https://github.com/greenplum-db/gpdb/releases/download/6.9.0/greenplum-db-6.9.0-rhel7-x86_64.rpm



一. 配置SSH无密码互相登陆:


登录每台机器:

切换到gpadmin用户:

#su - gpadmin


/* 生成公私密钥

$ ssh-keygen -t rsa


/* 在各个主机上使用ssh-copy-id命令拷贝public key到文件authorized_hosts

$ ssh-copy-id mdw 

输入密码gpadmin


$ ssh-copy-id smdw

输入密码


$ ssh-copy-id sdw2

输入密码


/* 在所有主机验证是否可以免密登陆

ssh mdw date

ssh smdw date

ssh sdw2 date


二.安装greenplum

在每台机器上安装Greenplum6.9版本的rpm包

# yum install -y greenplum-db-6.6.0-rhel7-x86_64.rpm

# chown -R gpadmin:gpadmin /usr/local/greenplum*



三. 配置Greenplum

创建一个hostlist,包含所有节点主机名

$ cat /home/gpadmin/conf/hostlist        

mdw

smdw

sdw2


创建一个 seg_hosts ,包含所有的Segment Host的主机名

$ cat /home/gpadmin/conf/seg_hosts

smdw

sdw2


把配置传给其他主机:

# su - gpadmin

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

$ gpssh-exkeys -f /home/gpadmin/conf/hostlist

$ gpssh-exkeys -f /home/gpadmin/conf/seg_hosts


测试免密连接是否成功:

$ ssh smdw #不需要密码即可登录;


$ gpssh -f /home/gpadmin/conf/hostlist

=> pwd

[smdw] /home/gpadmin

[sdw2] /home/gpadmin

[mdw] /home/gpadmin

=> exit

出现上面结果就是成功了



四、初始化数据库

1、创建资源目录

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

$ gpssh -f /home/gpadmin/conf/hostlist

=> mkdir -p /opt/greenplum/data/master

=> mkdir -p /opt/greenplum/data/primary

=> mkdir -p /opt/greenplum/data/mirror

=> mkdir -p /opt/greenplum/data2/primary

=> mkdir -p /opt/greenplum/data2/mirror


2、环境变量配置

在主节点进行环境变量配置(配置在gpadmin的用户权限下进行配置)

# su - gpadmin

$ vi /home/gpadmin/.bash_profile

# .bash_profile


# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi


# User specific environment and startup programs


PATH=$PATH:$HOME/.local/bin:$HOME/bin


export PATH



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

export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1

export PGPORT=6530

export PGUSER=gpadmin

source /usr/local/greenplum-cc/gpcc_path.sh


export PGDATABASE=gp_sydb


然后依次复制到各个子节点

$ scp /home/gpadmin/.bash_profile smdw:/home/gpadmin/


$ scp /home/gpadmin/.bash_profile sdw2:/home/gpadmin/


让环境变量生效

$ source .bash_profile


3、初始化前检查连通性

$ cd /usr/local/greenplum-db/bin


$ gpcheckperf -f /home/gpadmin/conf/hostlist -r N -d /tmp

/usr/local/greenplum-db-6.9.0/bin/gpcheckperf -f /home/gpadmin/conf/hostlist -r N -d /tmp


-------------------

--  NETPERF TEST

-------------------

[Warning] retrying with port 23012

NOTICE: -t is deprecated, and has no effect

NOTICE: -f is deprecated, and has no effect

NOTICE: -t is deprecated, and has no effect

NOTICE: -f is deprecated, and has no effect

NOTICE: -t is deprecated, and has no effect

NOTICE: -f is deprecated, and has no effect

NOTICE: -t is deprecated, and has no effect

NOTICE: -f is deprecated, and has no effect


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

==  RESULT 2020-09-10T09:34:37.472459

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

Netperf bisection bandwidth test

mdw -> smdw = 111.620000

sdw2 -> mdw = 110.600000

smdw -> mdw = 111.320000

mdw -> sdw2 = 111.640000


Summary:

sum = 445.18 MB/sec

min = 110.60 MB/sec

max = 111.64 MB/sec

avg = 111.29 MB/sec

median = 111.62 MB/sec



出现以上内容证明各个节点已经可以连通。


4、执行初始化

初始化 Greenplum 配置文件模板都在/usr/local/greenplum-db/docs/cli_help/gpconfigs目录下,gpinitsystem_config是初始化 Greenplum 的模板,此模板中 Mirror Segment的配置都被注释;创建一个副本,对其以下配置进行修改:


$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs

$ cp gpinitsystem_config initgp_config

$ vi initgp_config


# FILE NAME: gpinitsystem_config


# Configuration file needed by the gpinitsystem


################################################

#### REQUIRED PARAMETERS

################################################


#### Name of this Greenplum system enclosed in quotes.

ARRAY_NAME="Greenplum Data Platform"


#### Naming convention for utility-generated data directories.

SEG_PREFIX=gpseg


#### Base number by which primary segment port numbers 

#### are calculated.

PORT_BASE=6000


#### 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=(/data1/primary /data1/primary /data1/primary /data2/primary /data2/primary /data2/primary)

declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary /opt/greenplum/data/primary  /opt/greenplum/data2/primary /opt/greenplum/data2/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=/opt/greenplum/data/master


MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1


#### Port number for the master instance. 

MASTER_PORT=6530


#### 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


################################################

#### OPTIONAL MIRROR PARAMETERS

################################################


#### Base number by which mirror segment port numbers 

#### are calculated.

#MIRROR_PORT_BASE=7000


#### File system location(s) where mirror segment data directories 

#### will be created. The number of mirror locations must equal the

#### number of primary locations as specified in the 

#### DATA_DIRECTORY parameter.

declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror /opt/greenplum/data/mirror /opt/greenplum/data/mirror /opt/greenplum/data2/mirror /opt/greenplum/data2/mirror /opt/greenplum/data2/mirror)



################################################

#### OTHER OPTIONAL PARAMETERS

################################################


#### Create a database of this name after initialization.

DATABASE_NAME=gp_sydb 


#### Specify the location of the host address file here instead of

#### with the -h option of gpinitsystem.

MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts



master节点执行初始化;

gpinitsystem -c initgp_config -S -s standby  



[gpadmin@mdw gpconfigs]$ gpinitsystem -c initgp_config -S -s standby 

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file initgp_config

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in initgp_config, will set to default value

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed

20200909:10:12:20:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

..

20200909:10:12:21:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array

20200909:10:12:21:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20200909:10:12:21:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...

........

20200909:10:12:26:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host

20200909:10:12:26:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...

........

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, Completed

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master Configuration

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance name       = Greenplum Data Platform

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master hostname            = mdw

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master port                = 6530

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance dir        = /opt/greenplum/data/master/gpseg-1

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master Database            = gp_sydb

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master connections         = 250

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master buffers             = 128000kB

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Segment connections        = 750

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Segment buffers            = 128000kB

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Checkpoint segments        = 8

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Encoding                   = UNICODE

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Postgres param file        = Off

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db-6.9.0/bin/initdb

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db-6.9.0/lib

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Ulimit check               = Passed

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Array host connect type    = Single hostname per node

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [1]      = 10.100.75.192

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [2]      = 169.254.95.120

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [3]      = 172.17.0.1

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [4]      = 192.168.1.1

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master             = Not Configured

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Number of primary segments = 4

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Total Database segments    = 8

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Trusted shell              = ssh

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Number segment hosts       = 2

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring config           = OFF

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  6000    sdw2    /opt/greenplum/data/primary/gpseg0      2

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  6001    sdw2    /opt/greenplum/data/primary/gpseg1      3

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  6002    sdw2    /opt/greenplum/data2/primary/gpseg2     4

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  6003    sdw2    /opt/greenplum/data2/primary/gpseg3     5

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-smdw  6000    smdw    /opt/greenplum/data/primary/gpseg4      6

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-smdw  6001    smdw    /opt/greenplum/data/primary/gpseg5      7

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-smdw  6002    smdw    /opt/greenplum/data2/primary/gpseg6     8

20200909:10:12:36:119474 gpinitsystem:mdw:gpadmin-[INFO]:-smdw  6003    smdw    /opt/greenplum/data2/primary/gpseg7     9


Continue with Greenplum creation Yy|Nn (default=N):

> Y

20200909:10:12:49:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Building the Master instance database, please wait...

20200909:10:13:01:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Starting the Master in admin mode

20200909:10:13:04:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances

20200909:10:13:04:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

........

20200909:10:13:04:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

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

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed           = 8

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed              = 0

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed              = 0

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Deleting distributed backout files

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Removing back out file

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-No errors generated from parallel processes

20200909:10:13:40:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -m -d /opt/greenplum/data/master/gpseg-1

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/opt/greenplum/data/master/gpseg-1

20200909:10:13:41:125357 gpstop:mdw:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...

server shutting down

20200909:10:13:42:125357 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process

20200909:10:13:42:125357 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /opt/greenplum/data/master/gpseg-1

20200909:10:13:42:125357 gpstop:mdw:gpadmin-[ERROR]:-Failed to kill processes for segment /opt/greenplum/data/master/gpseg-1: ([Errno 3] No such process)

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /opt/greenplum/data/master/gpseg-1

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Setting new master era

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Master Started...

20200909:10:13:42:125462 gpstart:mdw:gpadmin-[INFO]:-Shutting down master

20200909:10:13:43:125462 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Process results...

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-   Successful segment starts                                            = 8

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-   Failed segment starts                                                = 0

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Successfully started 8 of 8 segment instances 

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /opt/greenplum/data/master/gpseg-1 

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-No standby master configured.  skipping...

20200909:10:13:44:125462 gpstart:mdw:gpadmin-[INFO]:-Database successfully started

20200909:10:13:44:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[WARN]:-were generated during the array creation

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Please review contents of log file

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20200909.log

20200909:10:13:49:119474 gpinitsystem:mdw:gpadmin-[INFO]:-To determine level of criticality

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-These messages could be from a previous run of the utility

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-that was called today!

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database instance successfully created

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-To complete the environment configuration, please 

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1"

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-   or, use -d /opt/greenplum/data/master/gpseg-1 option for the Greenplum scripts

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-   Example gpstate -d /opt/greenplum/data/master/gpseg-1

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20200909.log

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Review options for gpinitstandby

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-The Master /opt/greenplum/data/master/gpseg-1/pg_hba.conf post gpinitsystem

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-new array must be explicitly added to this file

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-located in the /usr/local/greenplum-db-6.9.0/docs directory

20200909:10:13:50:119474 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------


若初始化失败,需要删除/opt下的数据资源目录重新初始化;



五、数据库操作

登录数据库:

$ psql -p 6530

psql (9.4.24)

Type "help" for help.


gp_sydb=# 

gp_sydb=# 

gp_sydb=# 

gp_sydb=# 



停止和启动集群命令:

$ gpstop -M fast

$ gpstart -a


集群状态查看命令:

gpstate -e #查看mirror的状态

gpstate -f #查看standby master的状态

gpstate -s #查看整个GP群集的状态

gpstate -i #查看GP的版本

gpstate --help #帮助文档,可以查看gpstate更多用法


查看集群状态:

 [gpadmin@mdw gpconfigs]$ gpstate -f 

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53'

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-Standby master instance not configured

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:--pg_stat_replication

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:-No entries found.

20200909:10:23:07:138528 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

[gpadmin@mdw gpconfigs]$ gpstate -s

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -s

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53'

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:--Master Configuration & Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master host                    = mdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master postgres process ID     = 125520

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master data directory          = /opt/greenplum/data/master/gpseg-1

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master port                    = 6530

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master current role            = dispatch

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Greenplum initsystem version   = 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Greenplum current version      = PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Postgres version               = 9.4.24

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Master standby                 = No master standby configured

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-Segment Instance Status Report

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data/primary/gpseg0

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6000

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 151307

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data/primary/gpseg1

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6001

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 151306

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data2/primary/gpseg2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6002

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 151309

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data2/primary/gpseg3

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6003

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 151308

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data/primary/gpseg4

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6000

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 39878

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data/primary/gpseg5

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6001

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 39877

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data2/primary/gpseg6

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6002

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 39879

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Segment Info

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Address                           = smdw

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /opt/greenplum/data2/primary/gpseg7

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 6003

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-   Status

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 39880

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up

20200909:10:23:17:138776 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up

[gpadmin@mdw gpconfigs]$ 

[gpadmin@mdw gpconfigs]$ 


[gpadmin@mdw gpconfigs]$ gpstate -i 

20200909:10:23:51:139570 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -i

20200909:10:23:51:139570 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:23:51:139570 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53'

20200909:10:23:51:139570 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:23:51:139570 gpstate:mdw:gpadmin-[INFO]:-Loading version information

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   Host   Datadir                               Port   Version                                                                                                                                                                                                

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   mdw    /opt/greenplum/data/master/gpseg-1    6530   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /opt/greenplum/data/primary/gpseg0    6000   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /opt/greenplum/data/primary/gpseg1    6001   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /opt/greenplum/data2/primary/gpseg2   6002   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /opt/greenplum/data2/primary/gpseg3   6003   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   smdw   /opt/greenplum/data/primary/gpseg4    6000   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   smdw   /opt/greenplum/data/primary/gpseg5    6001   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   smdw   /opt/greenplum/data2/primary/gpseg6   6002   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-   smdw   /opt/greenplum/data2/primary/gpseg7   6003   PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53

20200909:10:23:52:139570 gpstate:mdw:gpadmin-[INFO]:-All segments are running the same software version


[gpadmin@mdw gpconfigs]$ gpstate -e 

20200909:10:22:56:138257 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -e

20200909:10:22:56:138257 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:10:22:56:138257 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53'

20200909:10:22:56:138257 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:10:22:56:138257 gpstate:mdw:gpadmin-[INFO]:-Physical mirroring is not configured

[gpadmin@mdw gpconfigs]$ 



备注:目前为止数据库已经安装和操作完毕,默认只有本地可以连数据库。如果需要别的机器可以连,需要修改gp_hba.conf文件:


vim $MASTER_DATA_DIRECTORY/pg_hba.conf 

#添加

host all gpadmin 0.0.0.0/0 md5

执行gpstop -u使配置生效


在从库上连接master测试:

$ psql -h 192.168.1.1 -d gp_sydb -p 6530

psql (9.4.24)

Type "help" for help.


gp_sydb=# 


修改gpadmin密码:

gp_sydb=# alter user gpadmin with password 'gpadmin';

ALTER ROLE


从库指定DB连接:


[gpadmin@smdw ~]$ psql -U gpadmin -h 192.168.1.1 -d gp_sydb -p 6530

Password for user gpadmin: 

psql (9.4.24)

Type "help" for help.


gp_sydb=# \l

                               List of databases

   Name    |  Owner  | Encoding |  Collate   |   Ctype    |  Access privileges  

-----------+---------+----------+------------+------------+---------------------

 gp_sydb   | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 

 postgres  | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 

 template0 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +

           |         |          |            |            | gpadmin=CTc/gpadmin

 template1 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +

           |         |          |            |            | gpadmin=CTc/gpadmin

(4 rows)


创建测试库:

gp_sydb=# create database test;

CREATE DATABASE


gp_sydb=# \c test

You are now connected to database "test" as user "gpadmin".

test=# 

test=# 

test=# create table test (id int primary key,name varchar(10));

CREATE TABLE

test=# 

test=# 

test=# \d test

            Table "public.test"

 Column |         Type          | Modifiers 

--------+-----------------------+-----------

 id     | integer               | not null

 name   | character varying(10) | 

Indexes:

    "test_pkey" PRIMARY KEY, btree (id)

Distributed by: (id)




test=# insert into test values(1,'zhengzhou');

INSERT 0 1

test=# insert into test values(2,'hangzhou'); 

INSERT 0 1

test=# insert into test values(3,'wenzhou'); 

INSERT 0 1

test=# insert into test values(4,'suizhou');

INSERT 0 1

test=# select * from test;

 id |   name    

----+-----------

  1 | zhengzhou

  3 | wenzhou

  4 | suizhou

  2 | hangzhou

(4 rows)


增加standy master方法:

[gpadmin@mdw ~]$ gpinitstandby -s sdw2

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for data directory /opt/greenplum/data/master/gpseg-1 on sdw2

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname               = mdw

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory         = /opt/greenplum/data/master/gpseg-1

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port                   = 6530

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname       = sdw2

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port           = 6530

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /opt/greenplum/data/master/gpseg-1

20200909:14:29:55:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog         = On

Do you want to continue with standby master initialization? Yy|Nn (default=N):

> Y

20200909:14:30:02:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby

20200909:14:30:02:200079 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on sdw2 are consistent.

20200909:14:30:02:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog...

20200909:14:30:02:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.

20200909:14:30:02:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file...

20200909:14:30:04:200079 gpinitstandby:mdw:gpadmin-[INFO]:-pg_hba.conf files updated successfully.

20200909:14:30:16:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Starting standby master

20200909:14:30:16:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Checking if standby master is running on host: sdw2  in directory: /opt/greenplum/data/master/gpseg-1

20200909:14:30:26:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...

20200909:14:30:27:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.

20200909:14:30:27:200079 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully created standby master on sdw2


查看standby master状态:

[gpadmin@mdw ~]$ gpstate -f

20200909:14:38:04:211012 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f

20200909:14:38:04:211012 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0'

20200909:14:38:04:211012 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.9.0 build commit:ef010af28862a0fed172ca96620cc1037aac71a0) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jun 29 2020 22:58:53'

20200909:14:38:04:211012 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-Standby master details

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-----------------------

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-   Standby address          = sdw2

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-   Standby data directory   = /opt/greenplum/data/master/gpseg-1

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-   Standby port             = 6530

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-   Standby PID              = 158229

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:-   Standby status           = Standby host passive

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--pg_stat_replication

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--WAL Sender State: streaming

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--Sync state: sync

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--Sent Location: 0/C0000A8

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--Flush Location: 0/C0000A8

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--Replay Location: 0/C0000A8

20200909:14:38:05:211012 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

[gpadmin@mdw ~]$ 



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

请登录后发表评论 登录
全部评论
交流MySQL,MongoDB和Redis技术。 微信或QQ:410294

注册时间:2015-12-07

  • 博文量
    754
  • 访问量
    2126611