GreenPlum配置standby及模拟master故障

环境信息：

Red Hat Enterprise Linux Server release 7.5 (Maipo)

Greenplum Database 5.16.0

[gpadmin@rhmdw gpadata]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.15.201  rhmdw
192.168.15.202  rhsdw1
192.168.15.203  rhsdw2

master为rhmdw，配置rhsdw1为standby。

在master检查状态：

[gpadmin@rhmdw gpadata]$ gpstate -b
20190329:20:15:39:006574 gpstate:rhmdw:gpadmin-[INFO]:-Starting gpstate with args: -b
20190329:20:15:39:006574 gpstate:rhmdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20190329:20:15:39:006574 gpstate:rhmdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jan 16 2019 02:32:15'
20190329:20:15:39:006574 gpstate:rhmdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20190329:20:15:39:006574 gpstate:rhmdw:gpadmin-[INFO]:-Gathering data from segments...
.. 
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-Greenplum instance status summary
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Master instance                                           = Active
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Master standby                                            = No master standby configured
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total segment instance count from metadata                = 4
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Primary Segment Status
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total primary segments                                    = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Mirror Segment Status
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total mirror segments                                     = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 2
20190329:20:15:41:006574 gpstate:rhmdw:gpadmin-[INFO]:-----------------------------------------------------

检查standby信息及环境master环境变量

[gpadmin@rhmdw gpadata]$ gpstate -f
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:-Starting gpstate with args: -f
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jan 16 2019 02:32:15'
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:-Standby master instance not configured
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:--pg_stat_replication
20190329:20:15:06:006508 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:15:07:006508 gpstate:rhmdw:gpadmin-[INFO]:-No entries found.
20190329:20:15:07:006508 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@rhmdw gpadata]$ env | grep MASTER
MASTER_DATA_DIRECTORY=/gp/gpdata/master/gpseg-1

在rhsdw1上使用gpadmin用户创建相关目录，配置环境变量

[gpadmin@rhsdw1 gpdata]$ mkdir -p /gp/gpdata/master

echo "export MASTER_DATA_DIRECTORY=/gp/gpdata/master/gpseg-1" >> ~/.bash_profile

开始配置standby：

[gpadmin@rhmdw gpadata]$ gpinitstandby -s rhsdw1
20190329:20:18:02:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20190329:20:18:03:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Checking for filespace directory /gp/gpdata/master/gpseg-1 on rhsdw1
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:------------------------------------------------------
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:------------------------------------------------------
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum master hostname               = rhmdw
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum master data directory         = /gp/gpdata/master/gpseg-1
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum master port                   = 5432
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum standby master hostname       = rhsdw1
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum standby master data directory = /gp/gpdata/master/gpseg-1
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Greenplum update system catalog         = On
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:------------------------------------------------------
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:- Filespace locations
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:------------------------------------------------------
20190329:20:18:04:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-pg_system -> /gp/gpdata/master/gpseg-1
Do you want to continue with standby master initialization? Yy|Nn (default=N):
> Y
20190329:20:18:06:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20190329:20:18:08:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-The packages on rhsdw1 are consistent.
20190329:20:18:08:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Adding standby master to catalog...
20190329:20:18:09:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Database catalog updated successfully.
20190329:20:18:09:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Updating pg_hba.conf file...
20190329:20:18:11:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20190329:20:18:17:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Updating filespace flat files...
20190329:20:18:17:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Filespace flat file updated successfully.
20190329:20:18:17:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Starting standby master
20190329:20:18:17:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Checking if standby master is running on host: rhsdw1  in directory: /gp/gpdata/master/gpseg-1
20190329:20:18:22:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20190329:20:18:24:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20190329:20:18:24:006770 gpinitstandby:rhmdw:gpadmin-[INFO]:-Successfully created standby master on rhsdw1

Master只存数据库的元数据，通常都很小，这个过程很快即可完成。

查看standby状态：

[gpadmin@rhmdw gpadata]$ gpstate -f
20190329:20:18:35:006889 gpstate:rhmdw:gpadmin-[INFO]:-Starting gpstate with args: -f
20190329:20:18:36:006889 gpstate:rhmdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20190329:20:18:36:006889 gpstate:rhmdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jan 16 2019 02:32:15'
20190329:20:18:36:006889 gpstate:rhmdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-Standby master details
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-----------------------
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-   Standby address          = rhsdw1
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-   Standby data directory   = /gp/gpdata/master/gpseg-1
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-   Standby port             = 5432
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-   Standby PID              = 3888
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:-   Standby status           = Standby host passive
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--pg_stat_replication
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--WAL Sender State: streaming
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--Sync state: sync
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--Sent Location: 0/C000000
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--Flush Location: 0/C000000
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--Replay Location: 0/C000000
20190329:20:18:37:006889 gpstate:rhmdw:gpadmin-[INFO]:--------------------------------------------------------------

模拟master故障：

关闭master端电源或关闭网卡，目前standby不会自动切换为master，需要手动切换

激活之前需要配置MASTER_DATA_DIRECTORY和GPPORT参数

[gpadmin@rhsdw1 gpdata]$ env | grep MASTER
MASTER_DATA_DIRECTORY=/gp/gpdata/master/gpseg-1
[gpadmin@rhsdw1 gpdata]$ gpactivatestandby -d $MASTER_DATA_DIRECTORY
20190329:20:32:47:004303 gpactivatestandby:rhsdw1:gpadmin-[CRITICAL]:-PGPORT environment variable not set.
[gpadmin@rhsdw1 gpdata]$ echo "export PGPORT=5432" >> ~/.bash_profile 
[gpadmin@rhsdw1 gpdata]$ . ~/.bash_profile 
[gpadmin@rhsdw1 gpdata]$ gpactivatestandby -d $MASTER_DATA_DIRECTORY
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:------------------------------------------------------
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Standby data directory    = /gp/gpdata/master/gpseg-1
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Standby port              = 5432
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Standby running           = yes
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Force standby activation  = no
20190329:20:34:12:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:------------------------------------------------------
Do you want to continue with standby master activation? Yy|Nn (default=N):
> Y
20190329:20:34:15:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-found standby postmaster process
20190329:20:34:15:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Updating transaction files filespace flat files...
20190329:20:34:15:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Updating temporary files filespace flat files...
20190329:20:34:15:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Promoting standby...
20190329:20:34:15:004316 gpactivatestandby:rhsdw1:gpadmin-[DEBUG]:-Waiting for connection...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Standby master is promoted
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Reading current configuration...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[DEBUG]:-Connecting to dbname='template1'
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Writing the gp_dbid file - /gp/gpdata/master/gpseg-1/gp_dbid...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-But found an already existing file.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Hence removed that existing file.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Creating a new file...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Wrote dbid: 1 to the file.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Now marking it as read only...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Verifying the file...
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:------------------------------------------------------
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-The activation of the standby master has completed successfully.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-rhsdw1 is now the new primary master.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-You will need to update your user access mechanism to reflect
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-the change of master hostname.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Do not re-start the failed master while the fail-over master is
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-operational, this could result in database corruption!
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-MASTER_DATA_DIRECTORY is now /gp/gpdata/master/gpseg-1 if
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-this has changed as a result of the standby master activation, remember
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-to change this in any startup scripts etc, that may be configured
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-to set this value.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-MASTER_PORT is now 5432, if this has changed, you
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-may need to make additional configuration changes to allow access
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-to the Greenplum instance.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Refer to the Administrator Guide for instructions on how to re-activate
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-the master to its previous state once it becomes available.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-Query planner statistics must be updated on all databases
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-following standby master activation.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:-When convenient, run ANALYZE against all user databases.
20190329:20:34:16:004316 gpactivatestandby:rhsdw1:gpadmin-[INFO]:------------------------------------------------------
[gpadmin@rhsdw1 gpdata]$ gpstate -b
20190329:20:34:27:004407 gpstate:rhsdw1:gpadmin-[INFO]:-Starting gpstate with args: -b
20190329:20:34:28:004407 gpstate:rhsdw1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20190329:20:34:28:004407 gpstate:rhsdw1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jan 16 2019 02:32:15'
20190329:20:34:28:004407 gpstate:rhsdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20190329:20:34:28:004407 gpstate:rhsdw1:gpadmin-[INFO]:-Gathering data from segments...
.. 
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-Greenplum instance status summary
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Master instance                                           = Active
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Master standby                                            = No master standby configured
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total segment instance count from metadata                = 4
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Primary Segment Status
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total primary segments                                    = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Mirror Segment Status
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total mirror segments                                     = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 2
20190329:20:34:30:004407 gpstate:rhsdw1:gpadmin-[INFO]:-----------------------------------------------------

检查mirror状态：

[gpadmin@rhsdw1 gpdata]$ gpstate -m
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-Starting gpstate with args: -m
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44'
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.16.0 build commit:23cec7df0406d69d6552a4bbb77035dba4d7dd44) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jan 16 2019 02:32:15'
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:--Current GPDB mirror list and status
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:--Type = Spread
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:--------------------------------------------------------------
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-   Mirror   Datadir                    Port   Status    Data Status    
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-   rhsdw2   /gp/gpdata/mirror/gpseg0   7000   Passive   Synchronized
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:-   rhsdw1   /gp/gpdata/mirror/gpseg1   7000   Passive   Synchronized
20190329:20:35:31:004512 gpstate:rhsdw1:gpadmin-[INFO]:--------------------------------------------------------------

[gpadmin@rhsdw1 gpdata]$ psql -d postgres -c "SELECT * FROM gp_segment_configuration;"
 dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port 
------+---------+------+----------------+------+--------+------+----------+---------+------------------
    2 |       0 | p    | p              | s    | u      | 6000 | rhsdw1   | rhsdw1  |             9000
    4 |       0 | m    | m              | s    | u      | 7000 | rhsdw2   | rhsdw2  |             8000
    3 |       1 | p    | p              | s    | u      | 6000 | rhsdw2   | rhsdw2  |             9000
    5 |       1 | m    | m              | s    | u      | 7000 | rhsdw1   | rhsdw1  |             8000
    1 |      -1 | p    | p              | s    | u      | 5432 | rhsdw1   | rhsdw1  |                 
(5 rows)