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