Greenplum6.x重新初始化

已于 2022-08-06 10:21:14 修改
阅读量1.1k 收藏 1
点赞数
分类专栏： Greenplum 文章标签： bash linux 开发语言
于 2022-07-03 21:10:33 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/u010895512/article/details/125585991
版权

换一种初始化方式

一. 规划目录

root用户登录操作

#master机器
mkdir -p /datax/master
chown gpadmin:gpadmin -R /datax/master
#standby 机器
mkdir -p /datax/master
chown gpadmin:gpadmin -R /datax/master
#两台segment机器
mkdir -p /datax/primary
mkdir -p /datax/mirror

chown gpadmin:gpadmin -R /datax
若之前目录下存在文件，清理

root登录master机器


# master
[gpadmin@mdw ~]$ su - gpadmin
#删除master的目录
[gpadmin@mdw ~]$ rm -rf /datax/master/*
#删除standby目录
[gpadmin@mdw ~]$ gpssh -h smdw -e 'rm -rf /datax/master/*'
[smdw] rm -rf /datax/master/*
[gpadmin@mdw ~]$

# 清理segment上的内容
[gpadmin@mdw ~]$ gpssh -f /tmp/seg_hosts
=> rm -rf /datax/primary/*
[sdw1]
[sdw2]
=> rm -rf /datax/mirror/*
[sdw1]
[sdw2]
=> rm -rf /datax/tbs_tmp/*
[sdw1]
[sdw2]
=> rm -rf /datax/tbs_tmp2/*
[sdw1]
[sdw2]
=> rm -f /tmp/.s.PGSQL.*.lock
[sdw1]
[sdw2]
=>

=> exit

二. 编辑初始化文件

root用户登录master机器操作

编辑配置文件,无mirror镜像

vi /tmp/gpinitsystem_config_no_mirror
#添加如下内容
ARRAY_NAME="gpdb"
SEG_PREFIX=gpseg
PORT_BASE=36000
declare -a DATA_DIRECTORY=(/datax/primary /datax/primary /datax/primary /datax/primary)

MASTER_HOSTNAME=mdw
MASTER_DIRECTORY=/datax/master
MASTER_PORT=5432
TRUSTED_SHELL=ssh
CHECK_POINT_SEGMENTS=8
ENCODING=UNICODE

在这里插入图片描述

修改配置文件

root用户登录master机器操作
注意这里的路径是/datax

su - gpadmin
# 检查 MASTER_DATA_DIRECTORY
[gpadmin@mdw ~]$ cat ~/.bash_profile | grep MASTER_DATA_DIRECTORY
[gpadmin@mdw ~]$ cat ~/.bashrc  | grep MASTER_DATA_DIRECTORY

# 修改.bashrc
[gpadmin@mdw ~]$ vi ~/.bashrc

#将MASTER_DATA_DIRECTORY换成最新的路径
export MASTER_DATA_DIRECTORY=/datax/master/gpseg-1
export PGPORT=5432
export PGDATABASE=gpdb
export LD_PRELOAD=/lib64/libz.so.1 ps

# 修改.bash_profile
[gpadmin@mdw ~]$ vi ~/.bash_profile
# 修改内容如下datax
export MASTER_DATA_DIRECTORY=/datax/master/gpseg-1

#分发

gpscp -f /tmp/hostlist ~/.bashrc  =:~
gpscp -f /tmp/hostlist ~/.bash_profile =:~

三. 执行初始化

gpadmin登录master机器

1. 执行安装master和standby

# 这里使用-h 参数
[gpadmin@mdw ~]$ gpinitsystem -c /tmp/gpinitsystem_config_no_mirror -h /tmp/seg_hosts -s smdw --mirror-mode=spread

初始化日志

[gpadmin@mdw tmp]$ gpinitsystem -c /tmp/gpinitsystem_config_no_mirror -h /tmp/seg_hosts -s smdw --mirror-mode=spread
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file /tmp/gpinitsystem_config_no_mirror
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in /tmp/gpinitsystem_config_no_mirror, will set to default value
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20220704:23:49:43:060317 gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
..
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[WARN]:-Option --mirror-mode supplied, but no mirrors have been defined, ignoring --mirror-mode option
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20220704:23:49:44:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
........
20220704:23:49:47:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host
20220704:23:49:48:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
........
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, Completed
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master Configuration
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance name       = gpdb
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master hostname            = mdw
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master port                = 5432
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance dir        = /datax/master/gpseg-1
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master Database            =
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master connections         = 250
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master buffers             = 128000kB
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Segment connections        = 750
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Segment buffers            = 128000kB
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Checkpoint segments        = 8
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Encoding                   = UNICODE
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Postgres param file        = Off
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Initdb to be used          = /greenplum/greenplum-db-6.18.2/bin/initdb
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /greenplum/greenplum-db-6.18.2/lib
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Ulimit check               = Passed
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [1]      = ::1
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [2]      = 192.168.0.110
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [3]      = fe80::20c:29ff:fe90:bf83
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master             = smdw
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Number of primary segments = 4
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Standby IP address         = ::1
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Standby IP address         = 192.168.0.113
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Standby IP address         = fe80::20c:29ff:feab:1f84
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Total Database segments    = 8
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Trusted shell              = ssh
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Number segment hosts       = 2
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring config           = OFF
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1  36000   sdw1    /datax/primary/gpseg0   2
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1  36001   sdw1    /datax/primary/gpseg1   3
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1  36002   sdw1    /datax/primary/gpseg2   4
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1  36003   sdw1    /datax/primary/gpseg3   5
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  36000   sdw2    /datax/primary/gpseg4   6
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  36001   sdw2    /datax/primary/gpseg5   7
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  36002   sdw2    /datax/primary/gpseg6   8
20220704:23:49:56:060317 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2  36003   sdw2    /datax/primary/gpseg7   9

Continue with Greenplum creation Yy|Nn (default=N):
> y
20220704:23:50:04:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Building the Master instance database, please wait...
20220704:23:50:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Starting the Master in admin mode
20220704:23:50:11:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20220704:23:50:11:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
........
20220704:23:50:11:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
find: ‘/greenplum/greenplum-db-6.18.2/greenplum-db-6.18.2’: Too many levels of symbolic links
..............................................
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed           = 8
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed              = 0
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed              = 0
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Removing back out file
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-No errors generated from parallel processes
20220704:23:50:59:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -m -d /datax/master/gpseg-1
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.18.2 build commit:1242aadf0137d3b26ee42c80e579e78bd7a805c7'
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/datax/master/gpseg-1
20220704:23:50:59:064925 gpstop:mdw:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20220704:23:51:00:064925 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20220704:23:51:00:064925 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /datax/master/gpseg-1
20220704:23:51:00:064954 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /datax/master/gpseg-1
20220704:23:51:00:064954 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20220704:23:51:00:064954 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.18.2 build commit:1242aadf0137d3b26ee42c80e579e78bd7a805c7'
20220704:23:51:00:064954 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20220704:23:51:00:064954 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Setting new master era
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Master Started...
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Shutting down master
20220704:23:51:01:064954 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
.
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Process results...
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-   Successful segment starts                                            = 8
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Successfully started 8 of 8 segment instances
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /datax/master/gpseg-1
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-No standby master configured.  skipping...
20220704:23:51:03:064954 gpstart:mdw:gpadmin-[INFO]:-Database successfully started
20220704:23:51:04:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20220704:23:51:04:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Starting initialization of standby master smdw
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for data directory /datax/master/gpseg-1 on smdw
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname               = mdw
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory         = /datax/master/gpseg-1
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port                   = 5432
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname       = smdw
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /datax/master/gpseg-1
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog         = On
20220704:23:51:04:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20220704:23:51:05:065070 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on smdw are consistent.
20220704:23:51:05:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog...
20220704:23:51:05:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.
20220704:23:51:05:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file...
20220704:23:51:06:065070 gpinitstandby:mdw:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20220704:23:51:08:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Starting standby master
20220704:23:51:08:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Checking if standby master is running on host: smdw  in directory: /datax/master/gpseg-1
20220704:23:51:09:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20220704:23:51:09:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20220704:23:51:09:065070 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully created standby master on smdw
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Successfully completed standby master initialization
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[WARN]:-were generated during the array creation
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Please review contents of log file
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20220704.log
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-To determine level of criticality
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-that was called today!
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database instance successfully created
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-To complete the environment configuration, please
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/datax/master/gpseg-1"
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-   or, use -d /datax/master/gpseg-1 option for the Greenplum scripts
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-   Example gpstate -d /datax/master/gpseg-1
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20220704.log
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20220704:23:51:09:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master smdw has been configured
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-failure review options for gpactivatestandby
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-The Master /datax/master/gpseg-1/pg_hba.conf post gpinitsystem
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-new array must be explicitly added to this file
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-located in the /greenplum/greenplum-db-6.18.2/docs directory
20220704:23:51:10:060317 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------



[gpadmin@mdw ~]$

2. 安装mirror

需要输入4次mirror的存储路径

# -p 设置的是偏移量，和primary的端口相加。primary_port + offset = mirror_database_port
[gpadmin@mdw tmp]$ gpaddmirrors  -p 1000

Enter mirror segment data directory location 1 of 4 >
/datax/mirror
Enter mirror segment data directory location 2 of 4 >
/datax/mirror
Enter mirror segment data directory location 3 of 4 >
/datax/mirror
Enter mirror segment data directory location 4 of 4 >
/datax/mirror

在这里插入图片描述

添加mirror安装日志

[gpadmin@mdw tmp]$ gpaddmirrors  -p 1000
20220704:23:51:44:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Starting gpaddmirrors with args: -p 1000
20220704:23:51:44:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.18.2 build commit:1242aadf0137d3b26ee42c80e579e78bd7a805c7'
20220704:23:51:44:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.18.2 build commit:1242aadf0137d3b26ee42c80e579e78bd7a805c7) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Nov 10 2021 00:05:30'
20220704:23:51:44:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20220704:23:51:44:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
Enter mirror segment data directory location 1 of 4 >
/datax/mirror
Enter mirror segment data directory location 2 of 4 >
/datax/mirror
Enter mirror segment data directory location 3 of 4 >
/datax/mirror
Enter mirror segment data directory location 4 of 4 >
/datax/mirror
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Greenplum Add Mirrors Parameters
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Greenplum master data directory         = /data/master/gpseg-1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Greenplum master port                   = 5432
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Batch size                              = 16
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Segment batch size                      = 64
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 1 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg0
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36000
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg0
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37000
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 2 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36001
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37001
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 3 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36002
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37002
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 4 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg3
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36003
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg3
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37003
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 5 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg4
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36000
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg4
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37000
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 6 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg5
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36001
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg5
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37001
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 7 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg6
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36002
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg6
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37002
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror 8 of 8
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance host        = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance address     = sdw2
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance directory   = /datax/primary/gpseg7
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Primary instance port        = 36003
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance host         = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance address      = sdw1
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance directory    = /datax/mirror/gpseg7
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-   Mirror instance port         = 37003
20220704:23:52:21:065515 gpaddmirrors:mdw:gpadmin-[INFO]:---------------------------------------------

Continue with add mirrors procedure Yy|Nn (default=N):
> y
20220704:23:52:27:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Starting to create new pg_hba.conf on primary segments
20220704:23:52:31:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Successfully modified pg_hba.conf on primary segments to allow replication connections
20220704:23:52:31:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-8 segment(s) to add
20220704:23:52:31:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Validating remote directories
20220704:23:52:31:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Configuring new segments
sdw1 (dbid 15): pg_basebackup: base backup completed
sdw1 (dbid 16): pg_basebackup: base backup completed
sdw1 (dbid 17): pg_basebackup: base backup completed
sdw1 (dbid 18): pg_basebackup: base backup completed
sdw2 (dbid 11): pg_basebackup: base backup completed
sdw2 (dbid 12): pg_basebackup: base backup completed
sdw2 (dbid 13): pg_basebackup: base backup completed
sdw2 (dbid 14): pg_basebackup: base backup completed
20220704:23:52:46:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Updating configuration with new mirrors
20220704:23:52:47:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Updating mirrors
20220704:23:52:47:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Starting mirrors
20220704:23:52:47:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-era is None
20220704:23:52:47:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
...........
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Process results...
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-******************************************************************
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Data synchronization will continue in the background.
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-Use  gpstate -s  to check the resynchronization progress.
20220704:23:52:58:065515 gpaddmirrors:mdw:gpadmin-[INFO]:-******************************************************************
[gpadmin@mdw tmp]$

四. 查看状态

[gpadmin@mdw tmp]$ gpstate -m

在这里插入图片描述

五. 重新安装监控软件

[gpadmin@mdw tmp]$  cd /opt/greenplum-cc-web-6.7.1-gp6-rhel7-x86_64
[gpadmin@mdw greenplum-cc-web-6.7.1-gp6-rhel7-x86_64]$ ls
gpccinstall.2022-07-04_215035.log  gpccinstall-6.7.1
[gpadmin@mdw greenplum-cc-web-6.7.1-gp6-rhel7-x86_64]$ ./gpccinstall-6.7.1
Where would you like to install Greenplum Command Center? (Default=/usr/local)
/greenplum
Greenplum Command Center will be installed in /greenplum/greenplum-cc-6.7.1

What would you like to name this installation of Greenplum Command Center? (Default=gpcc)


What port would you like the gpcc webserver to use? (Default=28080)


Would you like to enable SSL/TLS? Yy/Nn (Default=Y)
n

********************************************************************************
* WARNING: Your connections to GPCC will be insecure.                          *
********************************************************************************

Please choose a display language (Default=English)
1.  English
2.  Chinese
3.  Korean
4.  Russian
5.  Japanese
2

INSTALLATION IN PROGRESS...
********************************************************************************
* Please check your .pgpass file for the default password.                     *
* We recommend changing the default password for the gpmon user unless you     *
* plan to connect through LDAP or kerberos.                                    *
********************************************************************************
CREATING SUPERUSER 'gpmon'...
CREATING COMMAND CENTER DATABASE 'gpperfmon'...
RELOADING pg_hba.conf. PLEASE WAIT ...

********************************************************************************
*                                                                              *
* INSTALLATION IS ALMOST COMPLETED                                             *
*                                                                              *
* The last step is to update the metrics_collector extension, which needs to   *
* restart the Greenplum Database cluster. Please proceed to $GPCC_HOME and     *
* follow the instructions in this file:                                        *
*                                                                              *
*                            update-extension.txt                              *
*                                                                              *
* Some new features may not be available before the update is done.            *
*                                                                              *
* To use GPCC with the old metrics_collector extension, source gpcc_path.sh    *
* and run 'gpcc start'.                                                        *
*                                                                              *
********************************************************************************
[gpadmin@mdw greenplum-cc-web-6.7.1-gp6-rhel7-x86_64]$
[gpadmin@mdw greenplum-cc-web-6.7.1-gp6-rhel7-x86_64]$

六. 修改配置，设置访问权限

gpadmin用户在master机器操作

新增配置

[gpadmin@mdw ~] vi /tmp/all_gcc_hosts
#添加如下内容，所有机器信息,无多余的空格和换行
sdw
smdw
sdw1
sdw2

# 执行分发
[gpadmin@mdw ~] gpssh -f /tmp/all_gcc_hosts
cd ~
echo "source /greenplum/greenplum-cc/gpcc_path.sh" >> .bash_profile

exit
返回到

修改postgres.conf

[gpadmin@mdw ~]$ vi /datax/master/gpseg-1/postgresql.conf
#修改下列参数为
# 6版本默认为*
listen_addresses='*'

# Enable the performance monitor
gp_enable_gpperfmon=on
gpperfmon_port=8888
gp_external_enable_exec=on
gpperfmon_log_alert_level=warning


#其他参数设置暂时省略
# 重启，正常
gpstop -ra

在这里插入图片描述

修改pg_hba.conf

vi /datax/master/gpseg-1/pg_hba.conf 
# 末尾添加如下内容
# add config
host all gpmon 0/0 md5
host all gpmon 0.0.0.0/0 md5

#更新配置，正常
gpstop -u

在这里插入图片描述

修改.gppass

cd ~
vi .gppass
#内容如下
*:5432:gpperfmon:gpmon:gpmon


[gpadmin@mdw gpseg-1]$ psql -d postgres
psql (9.4.24)
Type "help" for help.

postgres=# alter role gpmon password 'gpmon';
ALTER ROLE
postgres=#

分发

cd ~
# 复制到standby节点
scp /datax/master/gpseg-1/postgresql.conf  gpadmin@smdw:/datax/master/gpseg-1/
scp /datax/master/gpseg-1/pg_hba.conf gpadmin@smdw:/datax/master/gpseg-1/  
scp ~/.pgpass gpadmin@smdw:/home/gpadmin

七. 启动

gpadmin用户在master机器操作

cd ~
#重启数据库
[gpadmin@mdw ~] gpstop -a -M fast
[gpadmin@mdw ~] gpstart -a

八. 配置监控用户密码（首次安装gpcc跳过）

[gpadmin@mdw tmp]$ psql -d postgres
psql (9.4.24)
Type "help" for help.

postgres=# alter user gpmon with password 'gpmon';
ERROR:  role "gpmon" does not exist

报错

重新创建用户（首次安装gpcc跳过）

postgres=# create user gpmon with password 'gpmon';
NOTICE:  resource queue required -- using default resource queue "pg_default"
CREATE ROLE
postgres=# \q


## 
[gpadmin@mdw bin]$ psql -d postgres
psql (9.4.24)
Type "help" for help.
postgres=# CREATE ROLE gpmon superuser PASSWORD 'gpmon' login;
postgres=# create database gpperfmon with owner gpmon;
postgres=# alter user gpmon with password 'gpmon';
postgres=# \q

启动监控

[gpadmin@mdw bin]$ gpcc start
2022-07-03 18:17:53 Starting the gpcc agents and webserver...
2022-07-03 18:18:06 Agent successfully started on 4/4 hosts
2022-07-03 18:18:06 View Greenplum Command Center at http://mdw:28080
[gpadmin@mdw bin]$

登录监控

用户密码：gpmon/gpmon

在这里插入图片描述
在这里插入图片描述

在这里插入图片描述

指标

在这里插入图片描述

磁盘情况

在这里插入图片描述

在这里插入图片描述

问题

问题1：is Greenplum instance already stopped?


[gpadmin@mdw tmp]$ gpstop
20220703:17:35:54:004389 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args:
20220703:17:35:54:004389 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20220703:17:35:54:004389 gpstop:mdw:gpadmin-[ERROR]:-gpstop error: postmaster.pid file does not exist.  is Greenplum instance already stopped?

查看环境变量

env

# 由于之前搭建的环境变量是MASTER_DATA_DIRECTORY=/data/master/gpseg-1

#重新执行如下
export MASTER_DATA_DIRECTORY=/datax/master/gpseg-1

# 执行gpstop成功
gpstop

gpstart

问题2：could not start server

[gpadmin@mdw pg_log]$ tail -20 /data/master/gpseg-1/pg_log/startup.log
2022-07-04 22:42:14.849116 CST,,,p35902,th-1832212352,,,,0,,,seg-1,,,,,"LOG","XX000","could not bind IPv6 socket: Address already in use",,"Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",,,,,,"StreamServerPort","pqcomm.c",503,
2022-07-04 22:42:14.849366 CST,,,p35902,th-1832212352,,,,0,,,seg-1,,,,,"WARNING","01000","could not create listen socket for ""*""",,,,,,,,"PostmasterMain","postmaster.c",1212,
2022-07-04 22:42:14.849506 CST,,,p35902,th-1832212352,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create any TCP/IP sockets",,,,,,,,"PostmasterMain","postmaster.c",1217,1    0xbeec3c postgres errstart (elog.c:557)
2    0xa0df21 postgres PostmasterMain (postmaster.c:1216)
3    0x6b1df1 postgres main (main.c:205)
4    0x7fdb8f64d555 libc.so.6 __libc_start_main + 0xf5
5    0x6bdadc postgres <symbol not found> + 0x6bdadc

2022-07-04 22:56:56.363108 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""stats sender process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2022-07-04 22:56:56.363510 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2022-07-04 22:56:56.363853 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""ic proxy process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2022-07-04 22:56:56.371576 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","XX000","could not bind IPv4 socket: Address already in use",,"Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",,,,,,"StreamServerPort","pqcomm.c",503,
2022-07-04 22:56:56.372136 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","XX000","could not bind IPv6 socket: Address already in use",,"Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",,,,,,"StreamServerPort","pqcomm.c",503,
2022-07-04 22:56:56.372560 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"WARNING","01000","could not create listen socket for ""*""",,,,,,,,"PostmasterMain","postmaster.c",1212,
2022-07-04 22:56:56.372855 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create any TCP/IP sockets",,,,,,,,"PostmasterMain","postmaster.c",1217,1    0xbeec3c postgres errstart (elog.c:557)
2    0xa0df21 postgres PostmasterMain (postmaster.c:1216)
3    0x6b1df1 postgres main (main.c:205)
4    0x7f38c6c7d555 libc.so.6 __libc_start_main + 0xf5
5    0x6bdadc postgres <symbol not found> + 0x6bdadc

[gpadmin@mdw pg_log]$

排查

[gpadmin@mdw pg_log]$ cd /data/master/gpseg-1/pg_log
[gpadmin@mdw pg_log]$
[gpadmin@mdw pg_log]$ tail /data/master/gpseg-1/pg_log/startup.log
2022-07-04 22:56:56.363853 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""ic proxy process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2022-07-04 22:56:56.371576 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","XX000","could not bind IPv4 socket: Address already in use",,"Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",,,,,,"StreamServerPort","pqcomm.c",503,
2022-07-04 22:56:56.372136 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"LOG","XX000","could not bind IPv6 socket: Address already in use",,"Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",,,,,,"StreamServerPort","pqcomm.c",503,
2022-07-04 22:56:56.372560 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"WARNING","01000","could not create listen socket for ""*""",,,,,,,,"PostmasterMain","postmaster.c",1212,
2022-07-04 22:56:56.372855 CST,,,p41166,th-902977408,,,,0,,,seg-1,,,,,"FATAL","XX000","could not create any TCP/IP sockets",,,,,,,,"PostmasterMain","postmaster.c",1217,1    0xbeec3c postgres errstart (elog.c:557)
2    0xa0df21 postgres PostmasterMain (postmaster.c:1216)
3    0x6b1df1 postgres main (main.c:205)
4    0x7f38c6c7d555 libc.so.6 __libc_start_main + 0xf5
5    0x6bdadc postgres <symbol not found> + 0x6bdadc

[gpadmin@mdw pg_log]$

5432 端口被占用，解决

[gpadmin@mdw pg_log]$ netstat -ano|grep "5432*"
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      off (0.00/0/0)
tcp        0      0 192.168.0.110:5432      192.168.0.113:64808     ESTABLISHED keepalive (2840.20/0/0)
tcp6       0      0 :::5432                 :::*                    LISTEN      off (0.00/0/0)
unix  2      [ ACC ]     STREAM     LISTENING     59100    /tmp/.s.PGSQL.5432
unix  2      [ ACC ]     STREAM     LISTENING     59198    /tmp/.s.PGSQL.ic_proxy.5432.22454
unix  3      [ ]         STREAM     CONNECTED     17543

#观察上述信息/tmp/.s.PGSQL.ic_proxy.5432.22454

# 终止掉
[gpadmin@mdw pg_log]$ kill -9 22454
[gpadmin@mdw pg_log]$ netstat -ano|grep "5432*"
tcp        0      0 192.168.0.110:5432      192.168.0.113:64808     TIME_WAIT   timewait (55.11/0/0)
unix  3      [ ]         STREAM     CONNECTED     17543
[gpadmin@mdw pg_log]$

# 启动
[gpadmin@mdw pg_log]$ gpstart

#报错如下问题3

问题3 ：gpstart:mdw:gpadmin-[ERROR]:-gpstart error: Do not have enough valid segments to start the array.

环境变量错误
.bashrc中的MASTER_DATA_DIRECTORY值指向的有问题

问题4：WARNING",“58P02”,"could not create log file directory ““gpperfmon/logs””

[gpadmin@mdw ~]$ cd $MASTER_DATA_DIRECTORY
[gpadmin@mdw gpseg-1]$ rm -rf $MASTER_DATA_DIRECTORY/gpperfmon

# master和standby两台机器配置文件都修改
[gpadmin@mdw gpseg-1]$ vi pg_hba.conf
注释掉gpmon相关参数
[gpadmin@mdw gpseg-1]$ vi postgresql.conf
注释掉添加的监控的四个参数

[gpadmin@mdw gpseg-1]$ gpstop -u

[gpadmin@mdw gpseg-1]$ gpstart
# 启动成功

# 修改配置 pg_hba.conf postgresql.conf，放开上述修改的gpmon相关几个注释

补充：若初始化不安装standy，单独安装

gpinitstandby -s smdw
四、GP安装笔记-greenplum数据库初始化
dockj的博客
03-20 3925
一、配置数据库存储目录 创建一个子节点主机列表文件，包含除去master节点和standby节点的其他节点的主机列表，放置在/opt/greenplum目录下，编辑文件seg_hosts，添加如下内容： kylin-203-117 kylin-203-122 在每台服务器上创建对应的数据库存储目录，由于一台服务器上配置四台数据库，两台为primary，两台为mirror [gpadmin@kyl...
GreenPlum5.x数据库集群安装手册
分享使人进步
09-23 648
博客首秀 GreenPlum5.x数据库集群安装手册 部署规划 服务器清单： 用途 hostname IP 主管理节点 dwmaster 192.168.2.101 segment节点1 seghost1 192.168.2.102 segment节点2 seghost2 192.168.2.103 一、环境设置 1、关闭防火墙： service firewalld stop systemctl ...
greenplum安装与初始化
04-16
Greenplum数据引擎软件 为新一代数据分析所需的大规模数据和复杂查询 功能所设计 支持众多商用硬件平台 基于PostgreSQL设计 支持ODBC/JDBC等多种接口
Greenplum的安装和初始化
yfstop的博客
09-29 973
文章目录操作系统配置开发环境系统设置系统参数配置添加主机名本地映射重启操作系统安装Greenplum添加用户创建节点文件配置主机互信安装初始化Greenplum使用Greenplum 节点分配： 地址 主机名 segment mirror 10.0.0.100 gp master 10.0.0.101 gp1 pseg0、pseg1 mseg4、mseg5 10.0.0.102 gp2 pseg2、gpseg3 mseg0、mseg1 10.0.0.103 gp3 pseg4、
Pivotal Greenplum® 6.9-安装指南-初始化Greenplum数据库系统
uddiqpl的专栏
06-28 928
初始化Greenplum数据库系统 介绍如何初始化Greenplum数据库系统。 本章中的说明假定您已按照配置系统中的说明准备好主机，并根据安装Greenplum数据库软件中的说明，在系统中的所有主机上安装了Greenplum Database软件。 本章包含以下主题： 总览 初始化Greenplum数据库 设置Greenplum环境变量 下一步 父主题：安装和升级Greenplum 总览 因为Greenplum数据库是分布式的，所以初始化Greenplum数据库管理..
Greenplum数据库集簇初始化——Initdb概述
肥叔菌的博客
01-13 3883
Greenplum如何从无到有？Greenplum使用PostgreSQL的初始化机制来初始化集群，PostgreSQL使用initdb创建一个PostgreSQL实例。initdb从无到有创建单个空的可用的PostgreSQL数据库，也就是在一个空的目录中创建PostgreSQL运行所需要的所有文件，包括全局数据字典、控制文件和三个数据库：template0、template1、postgres。由于PostgreSQL自身历史的原因，先创建template1数据库，然后拷贝整个目录成为另外两个数据库。为
CentOS7.x集群部署GreenPlum6.x
最新发布
weixin_42333235的博客
02-08 772
Greenplum主要由Master节点、Segment节点、interconnect三大部分组成。Greenplum master是Greenplum数据库系统的入口，接受客户端连接及提交的SQL语句，将工作负载分发给其它数据库实例（segment实例），由它们存储和处理数据。Greenplum interconnect负责不同PostgreSQL实例之间的通信。Greenplum segment是独立的PostgreSQL数据库，每个segment存储一部分数据。
GreenPlum安装详细步骤（CENTOS 6.x）
leijianghong1987的博客
02-28 2399
GreenPlum集群搭建安装步骤 另外参考：https://gp-docs-cn.github.io/docs/best_practices/sysconfig.html 一，安装说明 1.1环境说明 操作系统:CentOS 6.x 64bit Greenplum:Greenplum-db-5.10.2-rhel6-x86_64.rpm 1.2集群介绍 使用1个master，2个segment的...
Greenplum4.3.8.1安装包
05-28
6. **初始化数据库**： 安装完成后，你需要初始化Greenplum数据库集群。使用`gpinitsystem`工具，根据你的配置设定进行初始化。 7. **配置环境**： 安装完成后，需要将Greenplum的bin目录添加到PATH环境变量中，...
Greenplum 6安装指南（CentOS 7.X）
SaySyan的博客
05-27 681
一、基本概念 Greenplum是一个面向数据仓库应用的关系型数据库，因为有良好的体系结构，所以 在数据存储、高并发、高可用、线性扩展、反应速度、易用性和性价比等方面有非常 明显的优势。Greenplum是一种基于PostgreSQL的分布式数据库，其采用sharednothing架构，主机、操作系统、内存、存储都是自我控制的，不存在共享。 本质上讲Greenplum是一个关系型数据库集群，它实际上是由数个独立的数据库服务 组合成的逻辑数据库。与RAC不同，这种数据库集群采取的是MPP（Massively
greenplum 集群初始化问题总结
wanglolaini的博客
01-01 1118
greenplum 集群初始化问题相关解决方式
greenplum安装与初始化(单机版)
心似海
05-07 731
http://blog.chinaunix.net/u1/45990/showart_1901381.html greenplum安装与初始化(单机版) 一、系统安装与运行环境需求    1.1操作系统环境  RedHat Enterprise Linux 4.0  Hostname:szamy        momery:1.2G        free disk:3G     ...
《GreenPlum系列》GreenPlum初级教程-GreenPlum详细入门教程
https://blog.datasource.space
01-23 2411
01GreenPlum数据库介绍 02GreenPlum单节点安装 03GreenPlum系统管理 04GreenPlum数据类型 05GreenPlum语言DDL&DML&DQL 06GreenPlum函数
greenplum几个初始化文件内容
lanmh的专栏
09-26 271
1. gp_init_config   ARRAY_NAME="Greenplum Database"MACHINE_LIST_FILE=/opt/greenplum-db/cfg/gp_init_hostnameSEG_PREFIX=gpPORT_BASE=50000declare -a DATA_DIRECTORY=(/database/gp_subdir_0)MASTER_HOSTNA...
Greenplum或DeepGreen数据库对象的使用和管理
热门推荐
DataFlow范式
06-19 1万+
1. 创建文件空间 [gpadmin@cdha ~]$ gpfilespace -o gpfilespace_config   #当前目录下生成gpfilespace_config文件 Enter a name for this filespace> zhangyun_fs          #手工输入 primary location 1> /dbfast_zhangyun_tbs/pri
greenplum常见问题
yy8093的专栏
12-26 1836
谨以此记录使用greenplum过程中遇到的问题 2017-12-26 报错信息：  ERROR:  source database "template1" is being accessed by other users  DETAIL:  There are 1 other session(s) using the database.  解决办法：  1.使用p
Docker 中部署 Greenplum
magic_kid_2010的专栏
05-09 5055
一、环境准备 Docker docker-compose centos:7.5.1804 的 docker 镜像 greenplum-db-5.14.0-rhel7-x86_64.bin 二进制文件 1、查看 docker 和 docker-compose 版本 [bigdata@local-vm-320 gp]$ docker -v Docker version 19.03.5, build 633a0ea [bigdata@local-vm-320 gp]$ docker-compose
greenplum启动、停止、重启、节点修复指南
weixin_45561600的博客
01-06 3671
greenplum启动、停止、重启、节点修复指南
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值