1docker rm -f gpdb6
 2docker run -itd --name gpdb6 -h gpdb6 \
 3  -p 5431:5432 -p 28088:28080  \
 4  -v /sys/fs/cgroup:/sys/fs/cgroup \
 5  --privileged=true lhrbest/greenplum_gpcc:6.23.1 \
 6  /usr/sbin/init
 7
 8
 9docker exec -it gpdb6 bash
10su - gpadmin
11gpstart -a
12gpcc start
13
14gpcc status
15gpstate

1[root@lhrdb ~]# docker exec -it gpdb6 bash
 2[root@gpdb6 /]# su - gpadmin
 3Last login: Fri Mar 10 10:53:49 CST 2023 on pts/2
 4[gpadmin@gpdb6 ~]$ gpstart -a
 520230310:11:42:41:000281 gpstart:gpdb6:gpadmin-[INFO]:-Starting gpstart with args: -a
 620230310:11:42:41:000281 gpstart:gpdb6:gpadmin-[INFO]:-Gathering information and validating the environment...
 720230310:11:42:41:000281 gpstart:gpdb6:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source'
 820230310:11:42:41:000281 gpstart:gpdb6:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
 920230310:11:42:41:000281 gpstart:gpdb6:gpadmin-[INFO]:-Starting Master instance in admin mode
1020230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
1120230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Obtaining Segment details from master...
1220230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Setting new master era
1320230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Master Started...
1420230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Shutting down master
1520230310:11:42:42:000281 gpstart:gpdb6:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
16.
1720230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Process results...
1820230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
1920230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-   Successful segment starts                                            = 4
2020230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-   Failed segment starts                                                = 0
2120230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
2220230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
2320230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances 
2420230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
2520230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Starting Master instance gpdb6 directory /opt/greenplum/data/master/gpseg-1 
2620230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Command pg_ctl reports Master gpdb6 instance active
2720230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
2820230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Starting standby master
2920230310:11:42:44:000281 gpstart:gpdb6:gpadmin-[INFO]:-Checking if standby master is running on host: gpdb6  in directory: /opt/greenplum/data/master_standby/gpseg-1
3020230310:11:42:45:000281 gpstart:gpdb6:gpadmin-[INFO]:-Database successfully started
31[gpadmin@gpdb6 ~]$ gpcc start
322023-03-10 11:42:50 Starting the gpcc agents and webserver...
332023-03-10 11:42:53 Agent successfully started on 1/1 hosts
342023-03-10 11:42:53 View Greenplum Command Center at http://gpdb6:28080
35[gpadmin@gpdb6 ~]$ gpcc status
362023-03-10 11:42:57 GPCC webserver: running
372023-03-10 11:42:58 GPCC agents: 1/1 agents running
38[gpadmin@gpdb6 ~]$ gpstate 
3920230310:11:43:09:001214 gpstate:gpdb6:gpadmin-[INFO]:-Starting gpstate with args: 
4020230310:11:43:09:001214 gpstate:gpdb6:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source'
4120230310:11:43:09:001214 gpstate:gpdb6:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb  7 2023 22:54:40'
4220230310:11:43:09:001214 gpstate:gpdb6:gpadmin-[INFO]:-Obtaining Segment details from master...
4320230310:11:43:09:001214 gpstate:gpdb6:gpadmin-[INFO]:-Gathering data from segments...
4420230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-Greenplum instance status summary
4520230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
4620230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Master instance                                           = Active
4720230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Master standby                                            = gpdb6
4820230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Standby master state                                      = Standby host passive
4920230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total segment instance count from metadata                = 4
5020230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
5120230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Primary Segment Status
5220230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
5320230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total primary segments                                    = 2
5420230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 2
5520230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0
5620230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
5720230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
5820230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
5920230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
6020230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
6120230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
6220230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
6320230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
6420230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
6520230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Mirror Segment Status
6620230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
6720230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total mirror segments                                     = 2
6820230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 2
6920230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0
7020230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
7120230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 2
7220230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
7320230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 2
7420230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
7520230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 2
7620230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
7720230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number postmaster processes found                   = 2
7820230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0
7920230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 2
8020230310:11:43:10:001214 gpstate:gpdb6:gpadmin-[INFO]:-----------------------------------------------------
81[gpadmin@gpdb6 ~]$ 
82

1[gpadmin@gpdb6 ~]$ psql
 2psql (9.4.26)
 3Type "help" for help.
 4
 5postgres=# \l
 6                               List of databases
 7   Name    |  Owner  | Encoding |  Collate   |   Ctype    |  Access privileges  
 8-----------+---------+----------+------------+------------+---------------------
 9 gpperfmon | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 
10 lhrgpdb   | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 
11 postgres  | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 
12 template0 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +
13           |         |          |            |            | gpadmin=CTc/gpadmin
14 template1 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +
15           |         |          |            |            | gpadmin=CTc/gpadmin
16(5 rows)
17
18postgres=# select * from gp_segment_configuration ;
19 dbid | content | role | preferred_role | mode | status | port | hostname | address |                  datadir                   
20------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------
21    1 |      -1 | p    | p              | n    | u      | 5432 | gpdb6    | gpdb6   | /opt/greenplum/data/master/gpseg-1
22    2 |       0 | p    | p              | s    | u      | 6000 | gpdb6    | gpdb6   | /opt/greenplum/data/primary/gpseg0
23    4 |       0 | m    | m              | s    | u      | 7000 | gpdb6    | gpdb6   | /opt/greenplum/data/mirror/gpseg0
24    3 |       1 | p    | p              | s    | u      | 6001 | gpdb6    | gpdb6   | /opt/greenplum/data/primary/gpseg1
25    5 |       1 | m    | m              | s    | u      | 7001 | gpdb6    | gpdb6   | /opt/greenplum/data/mirror/gpseg1
26    6 |      -1 | m    | m              | s    | u      | 5433 | gpdb6    | gpdb6   | /opt/greenplum/data/master_standby/gpseg-1
27(6 rows)
28
29postgres=# 
30
31postgres=# select pg_sleep(9999);
32