本文档记录gpstate相关命令和选项的测试输出。
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 => 显示详细信息
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 ~]$
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]:------------------------------
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]:--------------------------------------------------------------
gpstart -d => 指定数据目录（默认值：$MASTER_DATA_DIRECTORY）
gpstate -e => 显示具有镜像状态问题的片段
[gpadmin@mdw ~]$ gpstate -e
20200421:15:35:58:014681 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -e
20200421:15:35:58:014681 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:35:58:014681 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'
20200421:15:35:58:014681 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:35:58:014681 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
.
20200421:15:35:59:014681 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:35:59:014681 gpstate:mdw:gpadmin-[INFO]:-Segment Mirroring Status Report
20200421:15:35:59:014681 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:35:59:014681 gpstate:mdw:gpadmin-[INFO]:-All segments are running normally
gpstate -f => 显示备用主机详细信息
[gpadmin@mdw ~]$ gpstate -f
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -f
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:36:32:014783 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'
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:-Standby master details
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:-----------------------
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:- Standby address = smdw
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:- Standby data directory = /greenplum/gpdata/master/gpseg-1
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:- Standby port = 5432
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:- Standby PID = 21942
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:- Standby status = Standby host passive
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--pg_stat_replication
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--WAL Sender State: streaming
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--Sync state: sync
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--Sent Location: 0/1C0000A8
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--Flush Location: 0/1C0000A8
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--Replay Location: 0/1C0000A8
20200421:15:36:32:014783 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@mdw ~]$
gpstate -i => 显示GRIPLUM数据库版本
[gpadmin@mdw ~]$ gpstate -i
20200421:15:39:24:014896 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -i
20200421:15:39:24:014896 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:39:24:014896 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'
20200421:15:39:24:014896 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:39:24:014896 gpstate:mdw:gpadmin-[INFO]:-Loading version information
.
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- Host Datadir Port Version
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- mdw /greenplum/gpdata/master/gpseg-1 5432 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- smdw /greenplum/gpdata/master/gpseg-1 5432 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary1/gpseg0 40000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror1/gpseg0 50000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary2/gpseg1 40001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror2/gpseg1 50001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary1/gpseg2 40000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror1/gpseg2 50000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary2/gpseg3 40001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror2/gpseg3 50001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary1/gpseg4 40000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror1/gpseg4 50000 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary2/gpseg5 40001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror2/gpseg5 50001 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
20200421:15:39:25:014896 gpstate:mdw:gpadmin-[INFO]:-All segments are running the same software version
[gpadmin@mdw ~]$
gpstate -m => 显示镜像实例同步状态
[gpadmin@mdw ~]$ gpstate -m
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -m
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:40:10:014993 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'
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:--Type = Group
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror1/gpseg0 50000 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror2/gpseg1 50001 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror1/gpseg2 50000 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror2/gpseg3 50001 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror1/gpseg4 50000 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror2/gpseg5 50001 Passive Synchronized
20200421:15:40:10:014993 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
gpstate -p => 显示使用端口
[gpadmin@mdw ~]$ gpstate -p
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -p
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:41:10:015051 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'
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:--Master segment instance /greenplum/gpdata/master/gpseg-1 port = 5432
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:--Segment instance port assignments
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:-----------------------------------
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- Host Datadir Port
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary1/gpseg0 40000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror1/gpseg0 50000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary2/gpseg1 40001
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror2/gpseg1 50001
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary1/gpseg2 40000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror1/gpseg2 50000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary2/gpseg3 40001
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror2/gpseg3 50001
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary1/gpseg4 40000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror1/gpseg4 50000
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary2/gpseg5 40001
20200421:15:41:10:015051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror2/gpseg5 50001
gpstate -Q => 快速检查主机状态
[gpadmin@mdw ~]$ gpstate -Q
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -Q
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:41:42:015110 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'
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:--Quick Greenplum database status from Master instance only
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------------
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-# of up segments, from configuration table = 12
20200421:15:41:42:015110 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------------
gpstate -s => 显示集群详细信息
[gpadmin@mdw ~]$ gpstate -s
20200421:15:42:20:015160 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -s
20200421:15:42:20:015160 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'
20200421:15:42:20:015160 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'
20200421:15:42:20:015160 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200421:15:42:20:015160 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
.
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:--Master Configuration & Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master host = mdw
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master postgres process ID = 20984
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master data directory = /greenplum/gpdata/master/gpseg-1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master port = 5432
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master current role = dispatch
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Greenplum initsystem version = 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4
20200421:15:42:21:015160 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
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Postgres version = 8.3.23
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Master standby = smdw
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Standby master state = Standby host passive
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-Segment Instance Status Report
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary1/gpseg0
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 2503
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror1/gpseg0
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 24293
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary2/gpseg1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 2502
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror2/gpseg1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 24292
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary1/gpseg2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 24290
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror1/gpseg2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 31699
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary2/gpseg3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 24291
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror2/gpseg3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 31700
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary1/gpseg4
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 31698
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror1/gpseg4
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50000
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 2504
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/primary2/gpseg5
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 40001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 31697
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Datadir = /greenplum/gpdata/mirror2/gpseg5
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Port = 50001
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Status
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- PID = 2505
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20200421:15:42:21:015160 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
[gpadmin@mdw ~]$
gpstate -v => 显示详细信息
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
