ITPub博客

首页 > 数据库 > > Greenplum实战--检查集群状态gpstate

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

作者:TTT1234 时间:2023-03-27 17:50:14 0 删除 编辑
  1. 查看进程命令
$gpssh -f /home/gpadmin/gpconfig/all_host -e "ps -eaf|grep green"
[ mdw] ps -eaf|grep green

[ mdw] gpadmin 2601 1 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/ 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 23:12 pts/15 00:00:00 grep --color=auto green

[sdw3] ps -eaf|grep green

[sdw3] gpadmin 7428 1 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 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 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 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 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 -y -E

[sdw3] gpadmin 26794 26741 23:12 pts/1 00:00:00 grep --color=auto green

[sdw1] ps -eaf|grep green

[sdw1] gpadmin 12608 1 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 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=

[sdw1] gpadmin 12610 1 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 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 23:12 pts/1 00:00:00 grep --color=auto green

[sdw2] ps -eaf|grep green

[sdw2] gpadmin 2053 1 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 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=

[sdw2] gpadmin 2055 1 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 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 23:12 pts/1 00:00:00 grep --color=auto green

1.检查状态 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 => 显示详细信息

  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) =

20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing =

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 =

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 =

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 =

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) =

20200419:00:52:04:001506 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing =

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 =

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 =

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 =

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 =

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:00817 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -b

20200419:23:22:44:00817 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'

20200419:23:22:44:00817 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:00817 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200419:23:22:44:00817 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...

.

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Master instance = Active

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Master standby = smdw

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Standby master state = Standby host passive

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total segment instance count from metadata = 12

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Primary Segment Status

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total primary segments = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total primary segment valid (at master) = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total primary segment failures (at master) =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Mirror Segment Status

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total mirror segments = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment valid (at master) = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment failures (at master) =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes missing =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as primary segments =

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as mirror segments = 6

20200419:23:22:45:00817 gpstate:mdw:gpadmin-[INFO]:------------------------------



  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/gpseg 40000 sdw2 /greenplum/gpdata/mirror1/gpseg 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. 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. 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: /CADFDD8

20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Flush Location: /CADFDD8

20200419:23:29:02:008621 gpstate:mdw:gpadmin-[INFO]:--Replay Location: /CADFDD8

  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/gpseg 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. gpstate -p => 显示使用端口
gpstate -p => 显示使用端口

[gpadmin@mdw ~]$ gpstate -p

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -p

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'

20200419:23:30:39:00881 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:00881 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:--Master segment instance /greenplum/gpdata/master/gpseg-1 port = 5432

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:--Segment instance port assignments

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:-----------------------------------

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- Host Datadir Port

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary1/gpseg 40000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror1/gpseg 50000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/primary2/gpseg1 40001

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/mirror2/gpseg1 50001

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary1/gpseg2 40000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror1/gpseg2 50000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw2 /greenplum/gpdata/primary2/gpseg3 40001

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/mirror2/gpseg3 50001

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary1/gpseg4 40000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror1/gpseg4 50000

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw3 /greenplum/gpdata/primary2/gpseg5 40001

20200419:23:30:39:00881 gpstate:mdw:gpadmin-[INFO]:- sdw1 /greenplum/gpdata/mirror2/gpseg5 50001

[gpadmin@mdw ~]$







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


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

[gpadmin@mdw ~]$ gpstate -Q

20200419:23:30:53:00886 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -Q

20200419:23:30:53:00886 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.10.2 build commit:b3c02f3acd880e2d676dacea36be015e4a3826d4'

20200419:23:30:53:00886 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:00886 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20200419:23:30:53:00886 gpstate:mdw:gpadmin-[INFO]:--Quick Greenplum database status from Master instance only

20200419:23:30:53:00886 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------------

20200419:23:30:53:00886 gpstate:mdw:gpadmin-[INFO]:-# of up segments, from configuration table = 12

20200419:23:30:53:008860 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------------

[gpadmin@mdw ~]$


  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., 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/gpseg

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/gpseg

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



本文来源:https://blog.csdn.net/murkey/article/details/105625328

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69953058/viewspace-3137124/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2019-11-13

  • 博文量
    566
  • 访问量
    5199