How to check the greenplum state

1. Check system status,  use command: gpstate

[gpadmin@sachi gpdba]$ gpstate

20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args:

20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28'

20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Gathering data from segments...

..

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-Greenplum instance status summary

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Master instance = Active

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Master standby = No master standby configured

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total segment instance count from metadata = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Primary Segment Status

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segments = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segment valid (at master) = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segment failures (at master) = 0

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid files found = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of /tmp lock files found = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number postmaster processes missing = 0

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number postmaster processes found = 2

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Mirror Segment Status

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Mirrors not configured on this array

20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------

[gpadmin@sachi gpdba]$

3. To show orts used by system,  use command: gpstate -p

[gpadmin@sachi gpdba]$ gpstate -p

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -p

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28'

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:--Master segment instance /home/gpmaster/gpsne-1 port = 5432

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:--Segment instance port assignments

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-----------------------------------

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- Host Datadir Port

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- sachi /disk1/gpdata1/gpsne0 40000

20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- sachi /disk2/gpdata2/gpsne1 40001

[gpadmin@sachi gpdba]$

4. To show segment mirror configuration, use command: gpstate -m

[gpadmin@sachi gpdba]$ gpstate -m

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -m

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28'

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:--------------------------------------------------------------

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:-physical mirroring not used

20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:--------------------------------------------------------------

[gpadmin@sachi gpdba]$

6. Show details on primary/mirror segment pairs that have potential issue,use command: gpstate -e

[gpadmin@sachi gpdba]$ gpstate -e

20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -e

20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28'

20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Physical mirroring is not configured

[gpadmin@sachi gpdba]$

7. To get Greenplum database version details, use command: gpstate -i

[gpadmin@sachi gpdba]$ gpstate -i

20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -i

20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'

20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28'

20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...

20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Loading version information

..

20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- Host Datadir Port Version

20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /home/gpmaster/gpsne-1 5432 PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28

20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /disk1/gpdata1/gpsne0 40000 PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28

20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /disk2/gpdata2/gpsne1 40001 PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28

20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:-All segments are running the same software version

[gpadmin@sachi gpdba]$