-
- 查看进程命令
$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 |
-
- 检查状态 gpstate
- 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 => 显示主镜像映射
-
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]:-------------------------------------------------------------- |
-
-
- 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 |
-
-
- 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 |
-
-
- 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 ~]$ |
-
-
- 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 ~]$
|
-
-
- 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 ~]$ |
-
-
- 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
|
-
-
- gpstate -v => 显示详细信息
-
|