Greenplum实战--检查集群状态gpstate

1. 1. 查看进程命令

$gpssh -f /home/gpadmin/gpconfig/all_host -e "ps -eaf|grep green"

[ mdw] ps -eaf|grep green [ mdw] gpadmin   2601     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/master/gpseg-1 -p 5432 --gp_dbid=1 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M master --gp_contentid=-1 -x 14 -E [ mdw] gpadmin   7772  7703  5 23:12 pts/0    00:00:00 python /usr/local/greenplum-db/./bin/gpssh -f /home/gpadmin/gpconfig/all_host -e ps -eaf|grep green [ mdw] gpadmin   7899  7843  0 23:12 pts/15   00:00:00 grep --color=auto green [sdw3] ps -eaf|grep green [sdw3] gpadmin   7428     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror1/gpseg2 -p 50000 --gp_dbid=10 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=2 [sdw3] gpadmin   7429     1  0 01:04 ?        00:00:01 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary2/gpseg5 -p 40001 --gp_dbid=7 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=5 [sdw3] gpadmin   7430     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror2/gpseg3 -p 50001 --gp_dbid=11 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=3 [sdw3] gpadmin   7431     1  0 01:04 ?        00:00:01 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary1/gpseg4 -p 40000 --gp_dbid=6 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=4 [sdw3] gpadmin   7593     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/master/gpseg-1 -p 5432 --gp_dbid=14 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M master --gp_contentid=-1 -x 0 -y -E [sdw3] gpadmin  26794 26741  0 23:12 pts/1    00:00:00 grep --color=auto green [sdw1] ps -eaf|grep green [sdw1] gpadmin  12608     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror1/gpseg4 -p 50000 --gp_dbid=12 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=4 [sdw1] gpadmin  12609     1  0 01:04 ?        00:00:02 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary1/gpseg0 -p 40000 --gp_dbid=2 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=0 [sdw1] gpadmin  12610     1  0 01:04 ?        00:00:02 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary2/gpseg1 -p 40001 --gp_dbid=3 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=1 [sdw1] gpadmin  12611     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror2/gpseg5 -p 50001 --gp_dbid=13 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=5 [sdw1] gpadmin  31663 31610  0 23:12 pts/1    00:00:00 grep --color=auto green [sdw2] ps -eaf|grep green [sdw2] gpadmin   2053     1  0 01:04 ?        00:00:02 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary1/gpseg2 -p 40000 --gp_dbid=4 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=2 [sdw2] gpadmin   2054     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror1/gpseg0 -p 50000 --gp_dbid=8 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=0 [sdw2] gpadmin   2055     1  0 01:04 ?        00:00:00 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/mirror2/gpseg1 -p 50001 --gp_dbid=9 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=1 [sdw2] gpadmin   2056     1  0 01:04 ?        00:00:02 /usr/local/greenplum-db-5.10.2/bin/postgres -D /greenplum/gpdata/primary2/gpseg3 -p 40001 --gp_dbid=5 --gp_num_contents_in_cluster=6 --silent-mode=true -i -M quiescent --gp_contentid=3 [sdw2] gpadmin  21101 21048  0 23:12 pts/1    00:00:00 grep --color=auto green

 

1. 1. 检查状态 gpstate
      1. gpstate 常用命令

gpstate -b => 显示简要状态

gpstate -c => 显示主镜像映射

gpstart -d => 指定数据目录（默认值：$MASTER_DATA_DIRECTORY）

gpstate -e => 显示具有镜像状态问题的片段

gpstate -f => 显示备用主机详细信息

gpstate -i => 显示GRIPLUM数据库版本

gpstate -m => 显示镜像实例同步状态

gpstate -p => 显示使用端口

gpstate -Q => 快速检查主机状态

gpstate -s => 显示集群详细信息

gpstate -v => 显示详细信息

 

1. 1. 1. gpstate

gpstate [gpadmin@mdw ~]$ gpstate 20200419:00:52:03:001506 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: 20200419:00:52:03:001506 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:00:52:03:001506 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:00:52:03:001506 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:00:52:03:001506 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments... . 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Master instance                                           = Active 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Master standby                                            = No master standby configured 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total segment instance count from metadata                = 12 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Primary Segment Status 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total primary segments                                    = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Mirror Segment Status 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segments                                     = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 6 20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- [gpadmin@mdw ~]$

 

1. 1. 1. gpstate -b

gpstate -b => 显示简要状态 [gpadmin@mdw ~]$ gpstate -b 20200419:23:22:44:008170 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -b 20200419:23:22:44:008170 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:22:44:008170 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:22:44:008170 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:22:44:008170 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments... . 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Master instance                                           = Active 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Master standby                                            = smdw 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Standby master state                                      = Standby host passive 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total segment instance count from metadata                = 12 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Primary Segment Status 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total primary segments                                    = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Mirror Segment Status 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segments                                     = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number postmaster processes found                   = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 6 20200419:23:22:45:008170 gpstate:mdw:gpadmin-[INFO]:------------------------------

 

1. 1. 1. gpstate -c => 显示主镜像映射

gpstate -c => 显示主镜像映射 [gpadmin@mdw ~]$ gpstate -c 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -c 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:--Type = Group 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Status                             Data State     Primary   Datadir                             Port    Mirror   Datadir                            Port 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw1      /greenplum/gpdata/primary1/gpseg0   40000   sdw2     /greenplum/gpdata/mirror1/gpseg0   50000 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw1      /greenplum/gpdata/primary2/gpseg1   40001   sdw2     /greenplum/gpdata/mirror2/gpseg1   50001 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw2      /greenplum/gpdata/primary1/gpseg2   40000   sdw3     /greenplum/gpdata/mirror1/gpseg2   50000 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw2      /greenplum/gpdata/primary2/gpseg3   40001   sdw3     /greenplum/gpdata/mirror2/gpseg3   50001 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw3      /greenplum/gpdata/primary1/gpseg4   40000   sdw1     /greenplum/gpdata/mirror1/gpseg4   50000 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:-   Primary Active, Mirror Available   Synchronized   sdw3      /greenplum/gpdata/primary2/gpseg5   40001   sdw1     /greenplum/gpdata/mirror2/gpseg5   50001 20200419:23:24:54:008305 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------

 

1. 1. 1. gpstate -e=> 显示具有镜像状态问题的片段

 

 

 

 

 

 

gpstate -e => 显示具有镜像状态问题的片段 [gpadmin@mdw ~]$ gpstate -e 20200419:23:27:37:008446 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -e 20200419:23:27:37:008446 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:27:37:008446 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:27:37:008446 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:27:38:008446 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments... . 20200419:23:27:39:008446 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:27:39:008446 gpstate:mdw:gpadmin-[INFO]:-Segment Mirroring Status Report 20200419:23:27:39:008446 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:27:39:008446 gpstate:mdw:gpadmin-[INFO]:-All segments are running normally

 

1. 1. 1. gpstate -f => 显示备用主机详细信息

gpstate -f => 显示备用主机详细信息 [gpadmin@mdw ~]$ gpstate -f 20200419:23:29:01:008621 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f 20200419:23:29:01:008621 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:29:01:008621 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:29:01:008621 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-Standby master details 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:----------------------- 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-   Standby address          = smdw 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-   Standby data directory   = /greenplum/gpdata/master/gpseg-1 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-   Standby port             = 5432 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-   Standby PID              = 7593 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-   Standby status           = Standby host passive 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--pg_stat_replication 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--WAL Sender State: streaming 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Sync state: sync 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Sent Location: 0/CADFDD8 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Flush Location: 0/CADFDD8 20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Replay Location: 0/CADFDD8

 

 

1. 1. 1. gpstate -m => 显示镜像实例同步状态

 

[gpadmin@mdw ~]$ gpstate -m 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -m 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:--Type = Group 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   Mirror   Datadir                            Port    Status    Data Status     20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw2     /greenplum/gpdata/mirror1/gpseg0   50000   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw2     /greenplum/gpdata/mirror2/gpseg1   50001   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw3     /greenplum/gpdata/mirror1/gpseg2   50000   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw3     /greenplum/gpdata/mirror2/gpseg3   50001   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw1     /greenplum/gpdata/mirror1/gpseg4   50000   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-   sdw1     /greenplum/gpdata/mirror2/gpseg5   50001   Passive   Synchronized 20200419:23:30:05:008776 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- [gpadmin@mdw ~]$

 

1. 1. 1. gpstate -p => 显示使用端口

 

gpstate -p => 显示使用端口 [gpadmin@mdw ~]$ gpstate -p 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -p 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:--Master segment instance  /greenplum/gpdata/master/gpseg-1  port = 5432 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:--Segment instance port assignments 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:----------------------------------- 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   Host   Datadir                             Port 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw1   /greenplum/gpdata/primary1/gpseg0   40000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /greenplum/gpdata/mirror1/gpseg0    50000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw1   /greenplum/gpdata/primary2/gpseg1   40001 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /greenplum/gpdata/mirror2/gpseg1    50001 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /greenplum/gpdata/primary1/gpseg2   40000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw3   /greenplum/gpdata/mirror1/gpseg2    50000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw2   /greenplum/gpdata/primary2/gpseg3   40001 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw3   /greenplum/gpdata/mirror2/gpseg3    50001 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw3   /greenplum/gpdata/primary1/gpseg4   40000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw1   /greenplum/gpdata/mirror1/gpseg4    50000 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw3   /greenplum/gpdata/primary2/gpseg5   40001 20200419:23:30:39:008810 gpstate:mdw:gpadmin-[INFO]:-   sdw1   /greenplum/gpdata/mirror2/gpseg5    50001 [gpadmin@mdw ~]$

 

 

1. 1. 1. gpstate -Q => 快速检查主机状态

 

gpstate -Q => 快速检查主机状态 [gpadmin@mdw ~]$ gpstate -Q 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -Q 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:--Quick Greenplum database status from Master instance only 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------------- 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-# of up segments, from configuration table     = 12 20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------------- [gpadmin@mdw ~]$

 

 

1. 1. 1. gpstate -s => 显示集群详细信息

 

gpstate -s => 显示集群详细信息 [gpadmin@mdw ~]$ gpstate -s 20200419:23:31:19:008902 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -s 20200419:23:31:19:008902 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4' 20200419:23:31:19:008902 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24' 20200419:23:31:19:008902 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20200419:23:31:19:008902 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments... . 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:--Master Configuration & Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master host                    = mdw 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master postgres process ID     = 2601 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master data directory          = /greenplum/gpdata/master/gpseg-1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master port                    = 5432 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master current role            = dispatch 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Greenplum initsystem version   = 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Greenplum current version      = PostgreSQL 8.3.23 (Greenplum Database 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 10 2018 07:30:24 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Postgres version               = 8.3.23 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Master standby                 = smdw 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Standby master state           = Standby host passive 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-Segment Instance Status Report 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/primary1/gpseg0 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 40000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 12609 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/mirror1/gpseg0 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 50000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 2054 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Segment status                    = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/primary2/gpseg1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 40001 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 12610 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/mirror2/gpseg1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 50001 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 2055 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Segment status                    = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/primary1/gpseg2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 40000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 2053 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/mirror1/gpseg2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 50000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 7428 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Segment status                    = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw2 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/primary2/gpseg3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 40001 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 2056 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/mirror2/gpseg3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 50001 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Mirror 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 7430 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Segment status                    = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw3 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/primary1/gpseg4 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 40000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Preferred role                    = Primary 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Mirror status                     = Synchronized 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Status 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      PID                               = 7431 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Configuration reports status as   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Database status                   = Up 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Segment Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Hostname                          = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Address                           = sdw1 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Datadir                           = /greenplum/gpdata/mirror1/gpseg4 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Port                              = 50000 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-   Mirroring Info 20200419:23:31:20:008902 gpstate:mdw:gpadmin-[INFO]:-      Current role                      = Mirror

 

 

1. 1. 1. gpstate -v => 显示详细信息